I have a report I am trying to automate based on a query. The Criteria
Section states [Enter Area:] How do I get the Macro to enter "South East" by
default? Thanks in advance
Dan,
You can't.
Another approach, instead of using a Parameter Query, is to put an
unbound textbox on a form where you are running the report from, where
the user can enter the Area criteria. You can set the Default Value
property for this textbox to "South East". Then, in the query criteria,
in the place of the existing parameter prompt, you refer to the textbox
on the form, using syntax such as...
[Forms]![NameOfForm]![NameOfTextbox]

Signature
Steve Schapel, Microsoft Access MVP
> I have a report I am trying to automate based on a query. The Criteria
> Section states [Enter Area:] How do I get the Macro to enter "South East" by
> default? Thanks in advance