Pull down box (from table) as criteria for running a query

[Sharon]

I've created a form so users can run different reports. Instead of having
them enter their name (using a query parameter) I'd like them to use a
pull-down list that has all their names. Once they select the name it should
be used for running the query.

How do I set this up?

 

[John W. Vinson/MVP]

I've created a form so users can run different reports. Instead of having
them enter their name (using a query parameter) I'd like them to use a
pull-down list that has all their names. Once they select the name it should
be used for running the query.

How do I set this up?

Put a Combo Box on the form (using the combo box wizard), based on a
table of user names (which I presume you have somewhere). Be aware
that user names aren't unique - I used to work with Dr. Lawrence David
Wise and his colleague, Dr. Lawrence David Wise; you'll want some sort
of unique UserID.

The query should reference a criterion of

=[Forms]![NameOfForm]![NameOfCombo]