Hi,
I have made a query to select multiple records (of a Yes/No type field in the table). All other fields of the query must be read only except this check box field. An easy solution given is to create a form (in Datasheet view) based on the query and choose NO for Enabled in property box. The problem is, that in this case, I am unable to filter the records (I need two fields to be filtered at least in order to select records and then click the check box in some of them). Kindly advise.
I have made a query to select multiple records (of a Yes/No type field in the table). All other fields of the query must be read only except this check box field. An easy solution given is to create a form (in Datasheet view) based on the query and choose NO for Enabled in property box. The problem is, that in this case, I am unable to filter the records (I need two fields to be filtered at least in order to select records and then click the check box in some of them). Kindly advise.