combo box not inserting record in table

[anoushka]

hi

i have attached a document with print screen of the form and combo box properties i am working on

the way it works is, when the user selects a code, the appropriate desciption, uoi and price is displayed. but for some reason the price combo value is not being written to the price field in the table. all the data on the form except for item desc and uoi is written to tbl_waste. the item info for the combo boxes comes from qry_items.

please help..i have been banging my head for days now...thanks

 

[ghudson]

Maybe I am too tired to think but I noticed that the control source in four of your fields is for the "code". Each field should have a unique control source, one for each field in the table.

Also, is the value you want from each combo box bound to the correct column number.

 

[anoushka]

if i change the control source from "code" to "price", then when i select an item in the code combo box, the price combo won't change (to the appropriate price for the item code selected).