how do i customize a parameter value box? by putting my own backgroud image,
choosing the title i want, adding menus etc.? then how would i attatch this
parameter value box to a form or report, or to a switchboard item when the
user clicks to retrieve certain/limited information from a report (for
instance only the students in Mr. B's class)?

someone said to create a modal form and use unbound ojects as criteria, but
how?

please help

Hello "Stout_cns".

"Stout_cns" wrote:
> how do i customize a parameter value box? by putting my own backgroud
> image, choosing the title i want, adding menus etc.? then how would i
> attatch this parameter value box to a form or report, or to a
> switchboard item when the user clicks to retrieve certain/limited
> information from a report (for instance only the students in Mr. B's
> class)?
>
> someone said to create a modal form and use unbound ojects as criteria,
> but how?

Create a form that has no record source.
Add textboxes or combo boxes that allow the user to enter the criteria.
Add an OK button that does whatever you want using the paramteter
values. For example:
use a query that uses Forms!YourParameterForm!aTextbox as criterion.
Or pass the criteria to a form or report using the WhereCondition
argument of the DoCmd.OpenForm or OpenReport methods (VBA).
The only thing I'm not sure about is "menues". I think you will have to use
the menu bar from Access (which is btw. not available to modal forms).

--
Regards,
Wolfgang