WHERE?!?!!?!?!?!? In Access 97

[indianadave]

How can I go about setting two criteria in the WHERE portion of the following command:

DoCmd.OpenForm "frmSiteInformation", acNormal, , Me!Code = strGetCustomerCode

I want to add the following criteria to the line:

Me!Site Code = strGetSiteCode

Help!

 

[InyoTom]

Have you tried:

Me!Code = strGetCustomerCode AND Me!Site = strGetSiteCode
Tom Budlong
TomBudlong@Bigfoot.com

 

[jimmythegeek]

Don't forget the proper syntax, first you don't need the "ME" in the WHERE clause of an OpenForm method unless you are referring to a field on the current form.

If the two functions return strings, then use the following (which I assume from the str prefix):

"Code = '" & strGetCustomerCode & "' AND Site = '" & strGetSiteCode & "'"

If they were to return numbers, then use the following:

"Code = " & strGetCustomerCode & " AND Site = " & strGetSiteCode Jim Lunde
compugeeks@hotmail.com
Custom Application Development