Prev: Return form and controls to default size
Next: Synchronize three or more combobox
From: Sarella on 11 Jan 2010 12:20

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!

From: Marshall Barton on 11 Jan 2010 16:41
Sarella wrote:
>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)

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Return form and controls to default size
Next: Synchronize three or more combobox