Can't enable checkbox in a subform

[Angel69]

Hi All,

I have a subform in datasheet view. In the main form I have various combo boxes to filter the data in the subform. I want to be able to check off the checkbox in the subform then filter all records that are checked, however, I am not able to check any of the checkboxes when I'm in my main form.

Example:
Sales Region, Order Date, are two fields

I can go in and select "north", "5/20/2013" then filter and let's say I get 55 records

So within the north region on 5/20/2013 I only want to select 5 of the 55 records by checking them off in the subform then in the main form I would drop down the unbound combo box to 'yes' and it would give me all records in the 'north' region with an order date of '5/20/2013' that I checked which should be 5 in this case. But, it won't let me check the box in the subform. Any ideas?

Thanks!

 

[Mihail]

Your subform is based on a query and that query is not updatable.
Take a look here.

OR (less probability)

Your subform do not allow edits.

 

[Angel69]

Thanks, but I can edit the data in the query and the subform is set to allow edits. Any other ideas?

 

[Angel69]

After clicking outside the form and opening the properties for both the main and subform I discovered it was locked. I unlocked it and works like a charm. Thanks!