Checkbox by Month

[Quan9r]

Background: I have a task table and a month table - I have them linked One to Many - the purpose is to query tasks by month:

I have a form with a unbound check box for each month

Here is my problem:
I'm having a problem getting my query to run - properly: Any ideas how I can pull up my unbound form with check boxes - click on a specific month - to view the tasks for that month- I have tried build statements like [Forms]![Tbl_Month]![January]=Yes but it doesn't work...I'm becoming more frustated buecause I know it can work.

 

[Rolliee]

what you are doing is working with ONE record - the form - and what you need to do is work with the recordset. Forget build statements and write VB code.

Rollie E