Desperate for help

[systemx]

Hi there,

I am desperate for some help on this. I'm completely new to Access and learning the hard way -

I have a mainform, with a subform based on a query. The mainform has combo boxes and a search function. When you select values from the combo boxes and click search, the subform requeries based on the selection.

I want to add check boxes that determine what fields appear in the query and I'm not sure how to go about this.

I have tried to write SQL in the query to see if the value of the checkbox is true - but have only succeeded in making ALL of the data disappear not just the field I want to 'hide'.

Is this the correct approach?

Thanks

systemx