D
DwayneConyers
Customer requests Access 2003 application -- one form contains six sub-forms
that represent checkboxes linked to foreign tables having yes/no values.
For example, one table has structure
id Autonumber Primary Key
item_1 Yes/No
item_2 Yes/No
item_3 Yes/No
The subforms are added to the form linking a value on the form (e.g., a
foreign key) to the id of the table that populates the subform. The design
should return one unique recordset of the subform for each page/recordset of
the main form.
Testing the form, the form loads and shows all the checkboxes greyed out.
The initial attempt at clicking one of the forms returns an error message
saying the object is either read-only (false) or open in design mode
(false). A subsequent click shows all clear checkboxes and accepts clicks.
Navigating away from that record and back again confirms that none of the
selections were saved.
Hope this makes sense. Appreciate assistance ASAP. Thanks.
that represent checkboxes linked to foreign tables having yes/no values.
For example, one table has structure
id Autonumber Primary Key
item_1 Yes/No
item_2 Yes/No
item_3 Yes/No
The subforms are added to the form linking a value on the form (e.g., a
foreign key) to the id of the table that populates the subform. The design
should return one unique recordset of the subform for each page/recordset of
the main form.
Testing the form, the form loads and shows all the checkboxes greyed out.
The initial attempt at clicking one of the forms returns an error message
saying the object is either read-only (false) or open in design mode
(false). A subsequent click shows all clear checkboxes and accepts clicks.
Navigating away from that record and back again confirms that none of the
selections were saved.
Hope this makes sense. Appreciate assistance ASAP. Thanks.