LookUp Box in Form

[dah]

Hi,

I have created a form which shows all members of an institute and a subform which lists all the workshops they have attended. The form works fine. I have a combo box set up to enter a number and this brings up all the participants information including the workshop subform info.

My question is how to set up a lookup box for the last name and first name. Currently, they are separate. I would like to have the first and last name come up together and just type in a little bit of a person's name. I tried the combo and list boxes but they only bring up the last name.

Any suggestions?

dah

 

[norman]

Hi

You can find a good example of this in the sample database "orders".

The orders form has a combo box which concatenates the first and last names of the sales person and uses the query qrysalesperson to do this

HTH
Norman