Placing value into text box

[Guest]

I have a form named Order form. On this for I am selecting customer name and
all text boxes are populated using code in text box control source
=Combo_From.Column(3). I am populating 11 different text boxes placing
customer’s address, phone etc. In Order table I have a field called Customer
Id and if I place code in control source Combo_From.Column(2) customer ID
shows on a form but it is not placed in that table. How I can populate
CustomerID text box and placed CustomerID in a table at the same time? Thanks

 

[Guest]

Hi Greg,

For data to be saved to your table, you need to have the control source set
to a field from your table. Unless you do this, you can populate that
control however you like and it will never save to your table.

Hope this helps...

Damian.

 

[Guest]

Ok thanks. Can I create 2 text boxes and populate customerid and for example
make it invisible then create second text box (set control source to customer
id filed from the table) and copy customerid from 1st text box to another
and how i can copy that value? Or there is a better way to do that?

 

[Douglas J. Steele]

Don't set the control source for the text boxes to the combo box: set it to
the field in the recordset. Then, populate the text boxes in the AfterUpdate
event of the combo box.

You do realize, of course, that you probably shouldn't be storing the
address in two different table?