Hi There. I have set up a query with a parameter field to print labels (full
page of the one). As the first and last name are in different fields, the
last name field appears then the first name SEPARATELY. is there any way a
paramater field can be a drop down box where the name is selected from a list
(it would need to show last name, fist name, middle name)... or is this
getting a bit complicated for a beginner? Thanks Len
You cannot get a query to give you a combo box.
But if you set up a form, you can refer to the combo boxes on the form
instead of popping up parameter boxes.
I'm assuming you have a table of clients (named tblClient) with these
fields:
ClientID AutoNumber primary key
FirstName Text
Surname Text
You also have a form named (say) Form1, and it has a combo named Combo1
which has a RowSource of:
SELECT ClientID, Surname & ", " & FirstName FROM tblClient ORDER BY
Surname, FirstName;
Now in query design, in the Criteria row under the ClientID field, you can
enter:
[Forms].[Form1][Combo1]
The report based on that query will then contain only the record for the
person chosen in the combo.
If you already have a form set up that could show the record for the person,
here's another approach:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> Hi There. I have set up a query with a parameter field to print labels
> (full
[quoted text clipped - 5 lines]
> (it would need to show last name, fist name, middle name)... or is this
> getting a bit complicated for a beginner? Thanks Len
len - 09 Dec 2005 04:40 GMT
Thanks Allen. Will check it out. Greatly appreciate your help.
Regards
Len
> You cannot get a query to give you a combo box.
>
[quoted text clipped - 33 lines]
> > (it would need to show last name, fist name, middle name)... or is this
> > getting a bit complicated for a beginner? Thanks Len