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

C

CJ

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.)
 
S

Sprinks

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
 
D

Douglas J. Steele

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.
 
Top