rs.FindFirst with Multiple Criteria??? 1

[VoodooRage]

Can you utilize the "FindFirst" method with multiple arguments for the search criteria?

For example if you want to find a record based on two criteria such as

rs.FindFirst "[CNUM] ='" & Forms!Frm!CNUM & "'" AND "[Item] = '" & Forms!Frm!List73 & "'"

can this be done?

As Always THANKS bunches!

 

[psemianonymous]

Yes. When using things like "FindFirst" or "filters", you're basically building the WHERE clause of an SQL statement. So, write it thus:

rs.FindFirst "[CNUM] ='" & Forms!Frm!CNUM & "' AND [Item] = '" & Forms!Frm!List73 & "'"

The AND goes inside the quotes, resulting in a string that at run-time looks something like:

rs.FindFirst "[CNUM] ='somevalue' AND [Item] = 'someotherval'"

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

 

[VoodooRage]

That was fantastic!

I really appreciate the help. I have been banging my head on this for an hour and a half!

This forum ROCKS!