Type mismatch bewilderment

[jon jomaco]

Hey, I found this website on google and had a search around to see if I could find a few answers to some problems. It has helped a lot, however, I have stumbled upon the type mismatch error. I have used some of suggested ideas on other threads (such as using 's) but still can't figure out why I am getting it.

Here is the code i am using:

Me.[OrderTotal] = DSum("OrderValue", "tblOrderLink", "OrderID ='" & Me.[OrderID] & "'")

I believe it's something to do with the end bit:

"OrderID ='" & Me.[OrderID] & "'

Since if i put in the ID that has to be found manually e.g. "OrderID = 22" (for the argument) it works fine.

Hope you can help, any information appreciated
Jon.

 

[RuralGuy]

Your [OrderID] is numeric so leave off the single quotes:

Me.[OrderTotal] = DSum("OrderValue", "tblOrderLink", "OrderID =" & Me.[OrderID] )

 

[jon jomaco]

Excellent, that works fine. I didn't realise that you do not have to put the " " around the whole thing.
Thanks a lot,
Jon.

 

[RuralGuy]

Glad I could help Jon.