Populating Combo box from subform

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

Guest

I have a main form that contains a combo box. The combo box has 3 columns,
two of which are hidden in the format: ID | Display Text | Calc Value. When
a user enters a new record, they see the display text in the combo box. What
is actually saved to the table is the ID value, and the calc value is used
during the save operation for some sundry calculations.

The user has the ability to find a previously saved record by clicking a
'Find' button. This brings up a modal popup subform that displays all the
records in the table in a datasheet view.

By clicking on a row in this subform, I populate the fields of the main
form. What I want to be able to do is, based upon the ID value that is on
the subform record, display the proper display text in the combo box. What I
would do in VB .NET is 'combobox.selectedindex = x', but I'm not seeing a way
to do that in VBA (I've not used VBA very much).

Is there a way to do this?

Thanks in advance,
 
Cyd said:
I have a main form that contains a combo box. The combo box has 3 columns,
two of which are hidden in the format: ID | Display Text | Calc Value. When
a user enters a new record, they see the display text in the combo box. What
is actually saved to the table is the ID value, and the calc value is used
during the save operation for some sundry calculations.

The user has the ability to find a previously saved record by clicking a
'Find' button. This brings up a modal popup subform that displays all the
records in the table in a datasheet view.

By clicking on a row in this subform, I populate the fields of the main
form. What I want to be able to do is, based upon the ID value that is on
the subform record, display the proper display text in the combo box. What I
would do in VB .NET is 'combobox.selectedindex = x', but I'm not seeing a way
to do that in VBA (I've not used VBA very much).
Click to expand...


This should be as simple as setting the combo box's value to
the bound column's value (ID as saved in the record).
 
Well, duh. I changed the field to bound and it does work. Thanks, Marshall.
I'm too used to having to code everything myself! ;-)
 
Back
Top