Changing the name of my command

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

Guest

On my switchboard I have an option to display a report based on filter. The
filter I have in my query is =Forms![Substitute Training Class]![Training
date]. This filter works great and lets me put dates for a Class List, the
only thing is when I select to run that report and the criteria box pops up
it has this Forms![Substitute Training Class]![Training date]. How can I get
the criteria box to just say Enter Date instead of seeing the whole formula.
 
By entering =Forms![Substitute Training Class]![Training date] as the query's
criteria, Access attempts to take the value from the Training date control on
the Substitute Training Class form. If the form is not open or if the
control does not exist on the form, Access will ask you to supply the value.

If, on the other hand, you want to execute a parameter query where the user
supplies the date, change the criteria to:

[Enter date: ]

Hope that helps.
Sprinks
 
Thanks! That worked, I guess I just missunderstood the formula below.

Sprinks said:
By entering =Forms![Substitute Training Class]![Training date] as the query's
criteria, Access attempts to take the value from the Training date control on
the Substitute Training Class form. If the form is not open or if the
control does not exist on the form, Access will ask you to supply the value.

If, on the other hand, you want to execute a parameter query where the user
supplies the date, change the criteria to:

[Enter date: ]

Hope that helps.
Sprinks

KRB said:
On my switchboard I have an option to display a report based on filter. The
filter I have in my query is =Forms![Substitute Training Class]![Training
date]. This filter works great and lets me put dates for a Class List, the
only thing is when I select to run that report and the criteria box pops up
it has this Forms![Substitute Training Class]![Training date]. How can I get
the criteria box to just say Enter Date instead of seeing the whole formula.
Click to expand...
Click to expand...
 
Back
Top