customize a parameter value box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...

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).
 
Back
Top