Forms: displaying latest record only on a linked form

[hibbie0762]

My database is centred on two main tables - a table of user details, and a table of events (approval dates). I have created linked forms (with underlying queries) to bring up the User detail records and then show an associated event form with one or more records for user approval dates. I now want to set up linked forms so that where a user is associated with multiple approval dates, only the record for the most recent approval date is displayed. Is there a way to do this? Any help would be appreciated - I'm stumped.

 

[Aivars]

Is your subform set "Continuous Forms"?

Aivars

 

[hibbie0762]

Thanks for the prompt response. The subform was set to single previously. I have just tried setting it to continuous but it does not appear to make any difference all events are still available when all I want to display is the most recent.

Perhaps I have to do something with the underlying query, which links two tables on a common UserID?

 

[AArt]

try making the query for the table sort by date descending, and select the first one in the 'totals' Also reset the form back to single, you don't need continous if you just want one record (plus its too hard to spell).