How do I write to a table from text box

[noweyout]

I have a combo box with several columns in it. When I select an item in the combo box, it will populate text boxes below.

I use the following to fill in the text boxes:

=[cboComboBox].[column](1)

Once the information is in the text box, how do I get that information to write to a table?

[RuralGuy]

Normally your Form would be bound to a query/table as would the controls on it. Then you already have what it takes to "write to a table" (sort of).

[ssanfu]

I would bind the text box to a field and use the after update event of the combo box to "push" the value into the text box.

[pbaldy]

More info, including a caution against it:

http://www.baldyweb.com/Autofill.htm

[noweyout]

It worked out perfectly! Thank you everyone! I don't quite get why I should be careful when doing this though. I will look into this further.

[RuralGuy]

The warning means you would just need to read up on Normalization. If you are satisfied then go ahead and use the Thread Tools and mark this thread as Solved.