Help with my Time Picker

[Chimp8471]

I cant seem to get my return time function to work, can someone have a look for me please,

when i open the form, LOGENTRYHD and click on the button to add the time, i keep getting a debug message appear.

it should open up the from called frmReturnTime so i can then select a time to be returned to the form.

please help

Andy

 

[MadMaxx]

Firstly when the user clicks the Time Called button you get a Type Mismatch. This is because you are trying to format a variable that contains no value. So in the code for frmReturnTime I added

pstrTime = Format(Now(), "h:nn AM/PM")

Now frmReturnTime Opens no problem.

I take it that you want the time they select to fill the Time called box.

Add this to the OK button from frmReturnTime.

Forms!LOGENTRYHD!txtTime.Value = pstrtime

I hope this was the problem you were talking about.

 

[Chimp8471]

sounds great thanks, will have a look later and post back if any problems