Selecting Users from a list when running a report

[MarkPtacek]

Objective: Have a manager select a user's ID from a list and have a
report generated based on the user that is selected.

Current Progress: I have created a run-time prompted query and based
a report on that query, so when the manager runs the report they can
"type" in the user's ID (but there is no error checking, thus the
desire for a list).
I have a UserId table with each employee and UserId listed that I
would like to be able to use since there are 100+ userids.

[Bob Quintal]

ma********@europasports.com (MarkPtacek) wrote in
news:60**************************@posting.google.c om:

Objective: Have a manager select a user's ID from a list and
have a report generated based on the user that is selected.

Current Progress: I have created a run-time prompted query
and based a report on that query, so when the manager runs the
report they can "type" in the user's ID (but there is no error
checking, thus the desire for a list).
I have a UserId table with each employee and UserId listed
that I would like to be able to use since there are 100+
userids.

Change your attack plan.

Build a query that selects distinct UserIDs.

Build a form with three controls: a combo box that uses the new
query as its row source, a print button, and a close form button.
Use the control wizard on the toolbar to build the buttons.

You can then just add to commands that the wizard to limit the
report to one user ID.

Remove the prompt from the query, it now duplicates info from the
form.

Bob Q