Dlookup

[Guest]

I have the following Dlookup with works fine:

DLookUp("TableAParts","EAU","[PARTNO]=Forms![NewPartInputfrm].PartNo")

I need to add the following criteria: AND where [REFPARTNO] in TableAParts =
Forms![NewPartInputfrm].RefPartNo")? Thank you.

Alex

 

[Steve Schapel]

Alex,

The structure of your DLookup function would imply that TableAParts is
the name of a field. So what does " [REFPARTNO] in TableAParts" mean.
Or, do you actually mean that your original DLookup is like this?...
DLookUp("[EAU]","TableAParts","[PARTNO]=Forms![NewPartInputfrm].PartNo")
If so, expand like this...
DLookUp("[EAU]","TableAParts","[PARTNO]=Forms![NewPartInputfrm].PartNo
AND [REFPARTNO]=Forms![NewPartInputfrm].RefPartNo")