text boxes

[kingsgambit]

I have a form where the user selects a product from a combo box, there is a text box on the form that fills in the product number, but it will not then save the produce number to the table.
The text box have a Row Source with =[Product].column(1).
How do I get the text box result to save into the table

 

[Rich]

I'd have thought that the product number assuming it's the PK should be the bound column of your combo, are you saving the product details in another table?

 

[kingsgambit]

The combo box is attached to a query, the query will show Product number and product, but the user should only need the select the produce.
The table only need to store User ID, Product Number, Produce.
The table is linked the another table which stores all the produce details. But I need to store the Product ID so I can link it the the details table. How can I get the product ID into a text box automatically and have it save the info into the table

 

[KevinM]

Assuming ProdID is the bound column(0)

In the afterUpdate event of the combo....

[TextBoxName] = ComboName

----

Where TextBoxName is the bound field to ProdID in your table