Multiple fields from a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used a combo box to show the value of a field obtained from a query.
(i.e. the data source is set to a query.)
I then added 2 other combo boxes, with the intent to capture two other
fields from the same query.
My question is: how do I get the 3 combo box to synchronize to the same
record each time the query is invoked via a change in one of the 3 combo
boxes.
Thanks.
David
 
Hi,


A single combo box with multiple columns (even if most are invisible). In
the AfterUpdate event of the combo box, push the other columns in standard
text edit controls:


Me.OtherControl = Me.ComboBoxName.Column( i ) ' i = 0 for the
first column


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top