Subform to open at last record entered

[Gilbertjoe]

Ok. This should be easy but I think my brain went on vacation.
I have a subform that opens when a command button is clicked on my main form. The main form and subform work ok. The subform will open when the command button is clicked(filtered) at the first record. How do I get the subform the open(filtered) at the last record entered but still allow the user to see/edit any previous entries?(the subform is displayed as continuous forms)

 

[TTThio]

Hello,

try with subform in datasheet, with this you'll be able to see the whole records related to the main form.

If you do update in the main form and need to have the subform displays the current one, add subform.requery/refresh on the button_click.

Tin Tin