Solved Dlookup with multiple NUMBER/Integer Criteria.

[Snuggle Walrus]

Hey all! Hopefully something simple, I think i'm just brainfarting this code, i'm trying to use a Variable to store a Dlookup value. I want to look up the "Unit Price" of the selected item from my Purchase Orders Details table.

CurrentBuyPrice = DLookup("[Unit Price]", "[tbl_PurchaseOrdersDetails]", "[POID]= '" & CurrentPOID & "' And [ProductID]= '" & CurrentPID & "'")

I'm getting type mismatch errors, I think its how i'm using my " and ' but i cant for the life of me seem to work it out at the moment. Both CurrentPOID and CurrentPID are variables storing Integers, have already been declared and are storing information correctly (used a msgbox to check). Thanks everyone!

 

[Minty]

You are surrounding your POID criteria and ProductID with ' ' making them text hence the type mismatch.
I assume they are numbers in which case remove the ' ' from your string concatenation.

 

[CJ_London]

if your fields are text, you use the single quote, if they are dates you use # and if they are numbers you don't use anything. So assuming your ID's are numbers

"[POID]= " & CurrentPOID & " And [ProductID]= " & CurrentPID

 

[theDBguy]

Hi. Try removing the apostrophes in your code.

Edit: Oops, too slow.

 

[Snuggle Walrus]

Doh that makes sense! Thanks everyone working great now!