Reuse a form

[QB]

I created a sub-form and it has a record source that list all the records
pertaining to a given ID. This works fine.

Now however, I would like to reuse this sub-form in a new form but only
display the last date entry.

How can I do this? I am trying to avoid creating a new form, because that
just leads to updating nightmares, keeping multiple versions in sync... I am
sure there is an easy way to do this that I am simply not aware of.

Thank you for the help,

QB

 

[Douglas J. Steele]

Why not just set the recordsource to a different query through code?

 

[KARL DEWEY]

A thought is to have a DMax on your main form with button for Last_Entry.
then include these in the Record Source for the subform.