I'm having a bit of trouble with the following code:
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[LNAME] = '" & Me![Combo66] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
It's in the after update in a combobox on my form. It works OK in that I can select a staff name (LNAME) either by typing the first few letters or scrolling to the name. However, if there are 10 Smiths it will only go to the first one.
How can I include the first name? I've tried using and but I can't get it to work.
Thanks.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[LNAME] = '" & Me![Combo66] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
It's in the after update in a combobox on my form. It works OK in that I can select a staff name (LNAME) either by typing the first few letters or scrolling to the name. However, if there are 10 Smiths it will only go to the first one.
How can I include the first name? I've tried using and but I can't get it to work.
Thanks.