DLookup with mulitple criteria on after exit 1

[air1jcw]

I have a form that I am working with. I am using the DLookup function. Here is my example:

varFLEETTYPE = DLookup("FLEETTYPE", "Fleet Effectivity", "!IID =[IID]&quot

varCPWOH = DLookup("OH", "gtiaiq", "[MATL TYPE]= 'SV' And [GTWY]= 'CPW'&quot

The first lookup (varFLEETTYPE) works fine. It returns the value based on what value is in the field [IID] on the form with no other criteria.
The second lookup up is what I am having trouble with (varCPWOH). I need for it return a value based on the value in the [IID] (field on form} AND with the criteria I have selected.

Any fixes for this?? If more info is needed - please advise.

Thank you in advanced!!

air

 

[THWatson]

air
I think you might have to bracket the criteria and then add the IID field.

Try this...
varCPWOH = DLookup("OH","gtiaiq","([MATL TYPE]= 'SV' And [GTWY]= 'CPW') And [IID] = " & [Forms]![YourFormName]![IID] & "&quot

I think that's close.

Tom