How do I use a multi-field combo box to select records on a form .

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

Guest

I have a table whose key is composed of multiple fields. The table requires
a columnar form, and I need to have a search bar that allows the users to
scroll through the record keys, select one, and then have the form go to that
record. I can get it to work with a single key table using a combo box, but
not when the table has multiple keys. Has anyone mastered this (I really
hope I don't have to do a lot of coding for such a simple idea.)
 
I'm sure that there is a way to do it through the use of a filter, but I
think it's much easier to avoide multiple field keys entirely by adding an
AutoNumber PK and a multiple field index to avoid duplicates of the
combination of those fields.

Hope that helps.
Sprinks
 
You can refer to the individual columns of the selected row in the combobox
as Me.MyComboBox.Column(0), Me.MyComboBox.Column(1), Me.MyComboBox.Column(2)
etc.
 
Back
Top