1 combo box populating more than one field and retaining info to t

[Sarella]

I have a combo box which when a selection is made also populates the 2 other
fields.

I found how to do this using this great link
http://www.blueclaw-db.com/download/fill_multiple_fields.htm

BUT !!

I want the retain the information that populates and feed it back to the
relevant table. The control source is how I would normally do this, but in
this instance the control source property is a formula to copy from the combo
box.

Is there a way round this?

Many thanks for your help - this is driving me nuts!

 

[Marshall Barton]

I have a combo box which when a selection is made also populates the 2 other
fields.

I found how to do this using this great link
http://www.blueclaw-db.com/download/fill_multiple_fields.htm

BUT !!

I want the retain the information that populates and feed it back to the
relevant table. The control source is how I would normally do this, but in
this instance the control source property is a formula to copy from the combo
box.

If the data in the combo box is not changable, it should not
be stored in the other table. Just the PK value form the
selected row should be stored in the other table as a
foreign key to the record with the rest of the fields.

If the data is changable and you need to keep track of what
it was at the time the combo box row was selected, then you
need to use a little VBA code to set the bound text boxes
instead of unbound text boex with expressions:

Me.txtfieldA = Me.combobox.Column(n)