Is it possible to use a Variable at the beginning of a Dlookup statement? For instance:
Dim Location as Variant
Dim PartStr as Variant
Dim CurrentQtyStr as String
Location=Combo26.Value
PartStr=Text11.Value
CurrentQtyStr = DLookup(["'& Location &'"], "dbo_Inv Master", "[Inventory Part]='" & PartStr & "'"
I think the formatting is correct because when the program breaks, It shows the value of "Location", but is errors saying "MS Access can't find the field '|' referred to in your expression"
Any thoughts?
Dodge
Dim Location as Variant
Dim PartStr as Variant
Dim CurrentQtyStr as String
Location=Combo26.Value
PartStr=Text11.Value
CurrentQtyStr = DLookup(["'& Location &'"], "dbo_Inv Master", "[Inventory Part]='" & PartStr & "'"
I think the formatting is correct because when the program breaks, It shows the value of "Location", but is errors saying "MS Access can't find the field '|' referred to in your expression"
Any thoughts?
Dodge