Open form

  • Thread starter Thread starter Bernd Smits
  • Start date Start date
B

Bernd Smits

Hello,
if I've created a "research for name" with a combobox, how can I, when I
double-click on a select name, open a form with the information about the
selected person?
Thanks
Bernd
 
Hi,
First, usually you have the PersonId field (or whatever you called it) as the bound column
of your combo.
Now, you design a form that pulls ALL the records.
You then use the OpenForm method utilizing the WhereCondition argument to
only display the info on the selected person:

DoCmd.OpenForm "yourForm",,,"PersonId = & Me.cboPerson

Substitute your form, control and field names.
 
Back
Top