How to have subforms default to last or new record.

[PaulA]

I am not having success in having a subform default to a new record when refreshed. The only event that seems to allow this is OnCurrent but then I can't go to other records in the subform to edit.

Help!

 

[Jack Cowley]

The only solution that pops into my mind is to put a toggle button on the form and change the Data Entry of the subform between True and False. When it is set to True you will only be able to enter new records. When set to false you will be able to see all your records so you can edit them. Your code to change the Data Entry might look like this:

Me.SubFormName.Form.DataEntry = True