subform help

[yarg1001]

I have created a subform which is a series of check boxes. When opening the form all of the checkboxes work. The subform is referenced directly to the underlying table.

When accessing the subform in the form itself the checkboxes are not editable. The form is pulled from a select query to pare down the number of records.

How can I get these fields to be usable.

[hyperpau]

I have created a subform which is a series of check boxes. When opening the form all of the checkboxes work. The subform is referenced directly to the underlying table.

When accessing the subform in the form itself the checkboxes are not editable. The form is pulled from a select query to pare down the number of records.

How can I get these fields to be usable.

your parent child link relationships are not set for your form and subform.
Based on how i picture your statement, you should have the underlying tables of your form and subform related in a many to many relationship. therefore, there should be a mediating table between the two. that table would have 2 foreign keys which are bound to the Primary key of the 1st table, and primary key of the 2nd table.

[yarg1001]

I have set the relationship in both the table relationship window and in the form/subform connection to no avail. The form is drawn from a select query on the same table that the subform pulls data from. going bald fast.

In the form I do not allow data entry but in the subform could this be an issue.

[yarg1001]

Once i changed the form to allow data entry then i could enter on the subform.