Findfirst

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a solution for the following problem. I have a DAO recordet rcdMtlu
and need to find a record based on two criteria, both criteria are declared
as strings both fileds are text boxes.

rcdMtlu.findfirst("firstname = " & Mname & "" and Lastname = " & Lname & """

I know this is a wild shot Help.
Jane
 
rcdMtlu.findfirst("[firstname] & [Lastname] = '" & Me!Mname & Me!Lastname &
"""
 
Try:

rcdMtlu.FindFirst "FirstName = """ & Me.Mname & _
""" AND LastName = """ & Me.Lname & """"

(assuming Firstname and LastName are Field names and Mname & Lname are
Control names)
 
Back
Top