Have a form look up field when creating a record

[mattmurdock]

Sorry that this might be hard to explain but here it goes.

I have a form (attached) that the user can insert the Name,Description, PIN #; select a Can Size and multiple Upcharges.
The form creates the record into table DNP.
The query "Items Form" takes DNP records and (will eventually) create total and discounted prices, etc.



Price is determined by Can Size as seen in the Can_Size table and SizePrice query. What I need is for when the user creates the record, the Price goes to DNP table AND/OR just the "Items Form". Price can not be on the form like it is for Can Size and Upcharges (yes I know its in the Can Size combo). I'm pretty stuck.

Any directions or guidance would be greatly appreciated- Thank you!

[June7]

Use VBA code to save the price to NDP table Price field:

Me!Price = Me.Combo113.Column(1)

Note that column index begins with 0. So since the price is in second column the index is 1.

The trick is figuring out what event to put the code in. In this case I think the combobox AfterUpdate will serve.