markptacek@europasports.com (MarkPtacek) wrote in
news:60c1e2b7.0312261134.4bdb17c8@posting.google.c om:
[color=blue]
> 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.
>[/color]
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
