setting Current record after ".addnew"

  • Thread starter Thread starter TracyG
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No Current record error 3
No Current record error 7
displaying recently added record 1
Infinite loops re-visited. 33
Adding a record from a text file 2
Error 3331 & validation rule error 1
DELETE FROM a table WHERE... 1
How do I add items to a multi-select listbox on the fly? 2

Back
Top