Subform Help!

[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

 

[John Vinson]

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