checkboxes in subform do not allow check or uncheck

[JacobTechy]

I have a subform in a form. The user clicks on the search button on the form based on text box criteria.

The results show up on the sub form in form view.

I have checkboxes(yes/no)in the results but the problem is that the user cannot check the boxes. No event ocurs. Its as though they are locked. I have checked the allowedits (yes), locked (no), enable (yes) on the subform and control but the issue continues to exist.

What can be the problem.

 

[TechnoDuh]

if the query the form is based upon is not updateable then you would not be able to change the records in the subform

 

[JacobTechy]

so how to you make the query updateable.

 

[JacobTechy]

so how should I set it up if I want to have a checkbox for each record result so the user can check what record he wants to include in the printable report. I dont need the check to save on the table of records.

 

[dhookom]

Consider using a multi-select list box.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]