Open form

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
 
D

Dan Artuso

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