After Update?

[johngordon]

Greetings,

I use the following code to update a form based on a Name selected from a combo box:

Private Sub Text73_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[LastName] = '" & Me![Text73] & "'"
Me.Bookmark = rs.Bookmark

End Sub

What I really want is for the code to select the individual by first and last name after update. The names are pulled from a query.

How do I include the [FirstName] into the code above?

Thanks,

John

 

[BabyPowder2u]

First question is, are you using ADO, or DAO recordset?

 

[johngordon]

DAO

 

[BabyPowder2u]

try
"[LastName] = '" & Me![Text73] & " [FirstName] = " & Me![namefield] & "

 

[johngordon]

Actually your reply made me think about what I was trying to do.

I finally used the following as a solution:

rs.FindFirst "[ClientID] = '" & Me![Text73] & "'"

Thanks for the quick reply!