DLookUp with Double Criteria

[txgeekgirl]

Good Morning. I am trying to tackle a DLookUp with double critieria.

Me.MPOIAuditItemsTB = DLookup("AuditItemsID", "FindingsElements", "[Element]= '" & Me.MPOIElementTB & "'" And "[AuditID]=" & Me.MPOIAuditTypeTB)

I can get it to work before the And and if I strip it out, after the AND, but not together. What am I missing???

 

[pbaldy]

It's not so much what you're missing, as what you have too many of. Try taking out the red items:

Me.MPOIAuditItemsTB = DLookup("AuditItemsID", "FindingsElements", "[Element]= '" & Me.MPOIElementTB & "'" And "[AuditID]=" & Me.MPOIAuditTypeTB)

 

[txgeekgirl]

Paul - you are a GENIUS - and guess what? I do know who John Galt is. And if you are organizing the island - I am there.

 

[pbaldy]

LOL! If only I had an island.