need a search form (1 Viewer)

[jdampf]

I am working on a training database. I want to search for a particular class by date. I have a subform with all of the classes listed in it above it a have a box labeled start date. I want the user to be able type in the date then hit enter and it would highlight the class in the subform or the class thats start date is closest to that date. Can anyone help??

 

[Travis]

You will need to make the subforms RecordSource a Query with the Date field's criteria the Date Field on the Main form. (example: [forms]![ParentForm]![DateField])

Then on the AfterUpdate of the Parent Form's Date Field Use this code:

Me.[SubFormName].Requery

This should give you the results your after.