Move back to original record

P

Patrick Graham

If the record is in a subform:

Clone the record set and find the first instance of a
unique field belonging to that record.

Dim rst As Object
Set rst = Me![subClient].Form.Recordset.Clone
rst.FindFirst "[ClientID] = " &
Me.lbxJointClientsLkUp.Column(2)
If Not rst.EOF Then Me![subClient].Form.Bookmark =
rst.Bookmark
rst.Close

If it is not a sub form i think you might not need to
clone the recordset. But i dont know for sure.
 

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

Mimic Split Form with Two Subforms 0
Bookmark not working on subform 5
Access 2007 "no current record" on split form 1
Using Findfirst recordset to search memo field type 11
Search and update with a combo box 1
Update subform's data from main form button -- A2007 3
Unique Key in Treeview 2
RecordsetClone not working Access 2007 3

Top