Pulling up a record by PK; combining fields for a dropdown

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

Guest

2 super easy questions:

1) Got a form. I'd like to pull up the record by the primary key. What
property on the control do I need to alter and how to let them type something
in and have it pull up the correct record?

2) Similar form. This time I want them to pull up a record with a dropdown
that combines 5 fields (i.e. EMEA Spain Women's Golfing Apparel) in the
dropdown list. Would it be like the lookup wizard allowing more than 1 column
to the dropdown?
 
2 super easy questions:

1) Got a form. I'd like to pull up the record by the primary key. What
property on the control do I need to alter and how to let them type something
in and have it pull up the correct record?
Click to expand...

Put an unbound Combo Box on the form, and have VBA code in that
combo's afterupdate event to find the record. The Combo Box wizard
will offer this as one option - "use this combo to find a record".
2) Similar form. This time I want them to pull up a record with a dropdown
that combines 5 fields (i.e. EMEA Spain Women's Golfing Apparel) in the
dropdown list. Would it be like the lookup wizard allowing more than 1 column
to the dropdown?
Click to expand...

A combo box can have up to ten fields; just include the fields in the
combo's RowSource property and set the Column Count to the desired
number, and the ColumnWidths to appropriate sizes for each.

John W. Vinson[MVP]
 
Back
Top