Checkbox to show field from query

[systemx]

Hi all,

I'm hoping someone can help me out with a problem.

I have a subform based on a query within my form. I also have a checkbox on that form.

I want to be able to add/remove fields from the query results based on whether the checkbox is selected.

In english...something like this....

If checkbox is checked THEN QUERY, FIELD, "SHOW" = Yes
ELSE QUERY, FIELD, "SHOW" = No

I have checked this forum, and access help files to no avail....I'm also really quite new at this Access game so any pointers or advice would be appreciated!

 

[Me!User]

Type of subform?

So the results of the query are displayed in the subform. Is the subform displayed in Datasheet mode?