A
Ana
Hello there,
I use Form1 to open Form2. Form1 has a search field combo with ID and
Field1.
Form2 opens with the records of Field1, it allows me to update and save.
When I repeat the process, with a new search, Form2 opens with the prior
viewed record.
I use the following command on combo when updated:
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.Find "[ID] = " & Str(Nz(Me![combo10], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
But it doesn't help.
What am I doing wrong?
TIA
Ana
I use Form1 to open Form2. Form1 has a search field combo with ID and
Field1.
Form2 opens with the records of Field1, it allows me to update and save.
When I repeat the process, with a new search, Form2 opens with the prior
viewed record.
I use the following command on combo when updated:
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.Find "[ID] = " & Str(Nz(Me![combo10], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
But it doesn't help.
What am I doing wrong?
TIA
Ana