ActiveX calendar for record navigation

[Gfunk13]

My goal is to click on the ActiveX calendar control and have the form move to the record the date selected.

It currently changes the value in the textbox has the same control source as the calendar. I want it to find the record with that date, rather than modify the date for the current record.

I've tried FindRecord and GoToRecord, but have found limitations with both.

This is my most recent attempt:

DoCmd.FindRecord "[Forms]![PROD_Main]![Text21]", acEntire, False, , False, , True

I believe the first argument should be text or a number rather than a control. Is there another way to do this?

 

[PHV]

You may try this:
DoCmd.FindRecord CDate(Forms!PROD_Main!Text21), acEntire, False, , False, , True

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886