I have a form for users to enter part numbers. The form has 5 text boxes for
each part. Part No1 has a text box for the user to enter his part no., along
with a description box, price box, a quantity box, and a total box.
After the user enters his part number the description and price will appear
in their respective boxes. The user then enters a quantity and the last
field is a calculated total.
I am using a DLookup for the price and description fields, but when I use the
following code...
Private Sub txtPartNo_AfterUpdate()
Me.txtPrice = Nz(Dlookup("NET PRICE", "parts_price_dump", "txtPartNo =
[ITEM]"),"")
Me.txtDescription = Nz(Dlookup("Description", "parts_price_dump",
"txtPartNo = [ITEM]"),"")
End Sub
....after entering the part number and pressing tab to go to the quantity
field an error box appears saying I have a missing query operator in the
query expression 'NET PRICE'.
What's going on. I had this working earlier with a different table. When I
switched tables and changed the name in my code it stopped working.
Any help would be greatly appreciated.
Shannan Casteel
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200508/1