after update hassles

[Pyro]

Hi,

I am setting up a subform that will update 2 tables: products in stock and products on order. the main form is for stocktaking purposes.

What i want to do is have an unbound combo that lists all products, a field for products in stock and a field for products on order. I want to display this on a continuous form for data entry purposes. What is the correct code for the afterupdate event so that when i enter a quantity into either total in stock or total on back order the productid will be stored in the foreign key field in my table(s).

I have tried to have the afterupdate event update a hidden text box that is bound to the relevent field but that does not work, or atleast not with:

txtnumber_in_stock_AfterUpdate()
Me.cboproduct_name = Me.txtproduct_id

The information that i want for the above example is bound to the first column of the combo.

Also i need the unbound combo box to hold its value when i tab to the next part of the continuous form.

Any help will be appreciated.