Go to previous record in subform-find first instance of not null

[ClifCamp]

I'm trying to have Access 97 look for the first instance of a date in a previous record in a subform. An individual will have many records and I want Access to look for the previous date if it finds a null in the current date field of the current record for the individual. Any help will be greatly appreciated. When I use GoToRecord , , acPrevious for After_Update in the date field in the subform, it goes to the previous record in the Parent form. Any help would be appreciated.

 

[beetee]

When you use GotoRecord, you have to make sure the correct form has focus. You can use GotoControl to set the focus onto a control on your subform.