I would like to know what the following command does:
Me.Bookmark = rs.LastModified
Does it set the forms current record to the rs.LastModified record?
VBA code example
-
- Administrator
- Posts: 78488
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: VBA code example
This will only work if rs is (a clone of) the recordset of the form; one way of setting it is a line
Set rs = Me.RecordsetClone
earlier in the code. It will then indeed make the record that was last modified by the code the active record in the form.
Set rs = Me.RecordsetClone
earlier in the code. It will then indeed make the record that was last modified by the code the active record in the form.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: VBA code example
Thank you, i wasn't sure about the RecordsetClone property.