Recent content by cykchanaa

I tried both methods but am still getting the error.

I am trying to create a form button that will automatically email each row of a query result to myself. At first the VBA code worked fine with a standard query. However when I use it with a query that contains a reference to a combobox form such as "<=[Forms]![Reminder]![Monthsleft].[Value] And...

Sorry for the confusion, I intend to generate a report based on my query and want users to have the option to choose which fields are shown in that report. I have attached a sample database for your reference.

Thanks for the suggestion, what I'm trying to do is to create a report based on that query and have a button opening that report on my form. However when I insert the query as a subform in datasheet view, hiding the columns has no effect on the report.

Currently I have a query where the criteria is dependent on the combo boxes on my form. I would like to add checkboxes to my form which determines which fields are shown or hidden. For example if I had a checkbox for address, selecting it on my form will show the address column in my query...