Combo box/List Box

  • Thread starter Thread starter Michele
  • Start date Start date
M

Michele

How do I write an expression for a combo or list box, so
that once the item (ID number)is selected for that box,
the form will populate with all the info for a particular
record.
thank you.
 
How do I write an expression for a combo or list box, so
that once the item (ID number)is selected for that box,
the form will populate with all the info for a particular
record.
thank you.
Click to expand...

The simplest way is to add a new combo box to your form using the
Combo Box wizard. When the wizard starts, select the 3rd option on the
first page of prompts, something like "Find a record on my form based
on .... etc." Continue answering the prompts.

When you select a record's ID in the combo box, the form fields will
fill in with the correct record's data.
 
Back
Top