Pop-up Form

[ispy1009]

I would like to create a pop-up form that asks the user what code from a
control on a different form to use to create a report that would be sorted by
the code selected. I know how to create the form and how to enter an unbound
control, but I am not sure how to have the report open using the selected
code.

 

[Jeff Boyce]

Is the additional (popup) form actually needed? If you already have the
user on a form, what about just adding a combobox (unbound) to that form
that lets the user select the ... ? ... code (I've noticed that many users
have difficulty remembering codes and resent having to write
down/remember/re-enter 'codes' rather than simply selecting by something
they know about -- e.g., finding a person by name rather than by
[EmployeeID]).

If you create a command button (<Run The Report>) and Open the report using
the DoCmd function, you can specify the WHERE condition to apply to the
report. In your case, the WHERE would be something like:

YourCode = Me!cboSelectACode

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP