Subform Help!

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

I have a subform on a main form. How do I go to the last record or a
new record on the subform when the form is open? The subform is base on a
query where
data is entered.

Thanks
 
I have a subform on a main form. How do I go to the last record or a
new record on the subform when the form is open? The subform is base on a
query where
data is entered.

You can put code in the Subform's Load event:

Private Sub Form_Load()
DoCmd.GoToRecord acLastRecord
End Sub
 
Back
Top