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


S

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?
 
Ad

Advertisements

J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top