Changing value imported from a combo box

[dome]

Greetings,

On my form I have a combo box that lists all of my products contained in a table.

When I select a product it fills a few text boxes on the form with info about that product.

Is it possible to change the info in the import text boxes, and then store the new value back into the table?
(i know that the info in the text box is bound to the combo box column)

Thanks in advance

Dome

 

[jwindon]

If these text boxes are bound to the same table that contains the information that is pulled by the combo, then yes, if you update them, the underlying table will be changed.

If you are using just that piece of a combo to fill in one value to another underlying source, you could consider using a subform that displays the information of the combo that IS linked back to the underlying table. Just be sure that you also assign the key information from the combo that you need in your MAIN FORM's underlying record source.