Hi Folks
Im looking for some pointers with a small problem that has just arisen while trying to use check boxes on a form.
What I have is a number of check boxes on the form (15 to be precise) that look for obviously check for true or false values within the data set. These check boxes relate to medical conditions.
I have a main form with the controls and then a subform showing the filtered results using said controls. Everything working ok so far.
I now need to export the filtered results to a spreadsheet, So i create another query that relects the controls in the main form in the query parameters, Ive added the text box and combo box controls and everything still working to plan, lastly I need to add the check box crieria and start adding one by one and this works for the first 5 checkboxes but on the 6th, Access tells me the criteria is complex to evaluate?????? I remove the 6th check box, but with the same result
I then remove them one by one and its not until I remove the check box criteria that it works again 
Any ideas???
Im looking for some pointers with a small problem that has just arisen while trying to use check boxes on a form.
What I have is a number of check boxes on the form (15 to be precise) that look for obviously check for true or false values within the data set. These check boxes relate to medical conditions.
I have a main form with the controls and then a subform showing the filtered results using said controls. Everything working ok so far.
I now need to export the filtered results to a spreadsheet, So i create another query that relects the controls in the main form in the query parameters, Ive added the text box and combo box controls and everything still working to plan, lastly I need to add the check box crieria and start adding one by one and this works for the first 5 checkboxes but on the 6th, Access tells me the criteria is complex to evaluate?????? I remove the 6th check box, but with the same result


Any ideas???