Enter Parameter Value

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

Guest

Hi,

Using conditions in queries forces a small box with the title Enter
Parameter Value.
Do you know how to change "Enter Parameter Value" to a different title?

Flemming Ast
 
The queries were never really intended to be the end-user interface, so the
parameter boxes do not provide for custom titles, range checking, drop-down
lists, entering multiple parameters in one dialog, and so on.

You could use a small unbound form or your own to enter these things.
Depending on where this is going, you could just reference the form in the
Criteria of your query, e.g.:
[Forms].[Form1].[Text1]
or you could build up a WhereCondition for an OpenForm/OpenReport as
illulstrated in:
Limiting a Report to a Date Range
at:
http://members.iinet.net.au/~allenbrowne/casu-08.html
 
Back
Top