setting Current record after ".addnew"

T

TracyG

I have added a new table record using access basic code - how do I set the
newly added record as the current record in the form?
 
A

Allen Browne

If you used AddNew on the RecordsetClone of the form, just use the
LastModified bookmark:

With Me.RecordsetClone
.AddNew
!SomeField = SomeValue
'etc
.Update
Me.Bookmark = .LastModified
End With
 
Top