ACC2000: Can't do AND Search using 2 search keys?

Joined
Jul 21, 2005
Messages
1
Reaction score
0
Hello group,

I am trying to search using several search keys. In my case I want to search by Last Name and First Name.
Heres the code that I am using: (on Query x: Last Name Sorted (ASC), First Name Sorted (ASC) )

DoCmd.ShowAllRecords
DoCmd.GoToRecord , , acFirst

If strLast <> "" Then
DoCmd.GoToControl "Last Name"
DoCmd.FindRecord strLast, acEntire, , acDown, , acCurrent
First_Name.SetFocus
End If

If strFirst <> "" Then
DoCmd.GoToControl "First Name"
DoCmd.FindRecord strFirst, acEntire, , acDown, , acCurrent
End If




What is happening is the Last name "????" is found. Since they are sorted by last name first, I am assuming that searching further down will find the first name "????". However, the cursor seems to be starting from the beginning again. Can someone please give me the simplest approach to do 1 AND Search using 2 columns? (First Name and Last Name)

Thank You,
tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top