Prompt to show field parameter query

[Sonja]

Hi,

Just wondering if anyone knows whether I can add a prompt to a parameter
query to ask whether to show that field or not ?

I know I can tick (or untick) the box in design view to show or hide the
field, but I want users to have the option to display on a form, I just can't
work out whether it's possible.

Thanks,

 

[Allen Browne]

No. Parameters are not that powerful. You need to use another approach to
handle parameters that my not be needed.

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
The article explains how you can make a form with lots of boxes where the
user can enter criteria, and then build up the Filter for your form, the
WhereCondition for OpenReport, or even the full SQL property for your
QueryDef.

 

[Duane Hookom]

I try to never use parameter prompts since they are not very functional.
However you could probably add a column in your query like:

FieldTitle: IIf([Display Field (Y/N):]="Y", [FieldName],Null)