Runtime Error 3075, missing operator in query expression

[kiwieur]

Hi,

I am trying to use the following code in an access form

BSize = HSlit & " x " & HalfChop
BundleSize = BSize
BLayer = (DLookup("Bun_Layer", "tblPalletData", "CaseSize = " & BSize))

However I keep getting a Runtime Error 3075, missing operator in query expression.

HSlit = 350 & HalfChop = 350 in this instance, If I change the DLookup to

BLayer = (DLookup("Bun_Layer", "tblPalletData", "CaseSize = '350 x 350'"))

Then I get a value of 9 returned which is correct, I have been looking at this all afternoon and cannot seem to work out what the problem is.

Can anyone help me please

Regards

Paul

 

[kiwieur]

It's Ok figured it out now changed the DLookup to the following

BLayer = (DLookup("Bun_Layer", "tblPalletData", "CaseSize = " & "'" & BSize & "'"))

Thank anyway if anyone was looking at this

Regards

Paul