URGENT Sub-Forms Not Behaving

[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.

 

[Michael Cheng [MSFT]]

Hi Dwayne,

Thanks for your posting!

I take the ownership of this thread and will help you on this issue. I am
looking further into this issue and will update you as soon as possible
when I find anything valueable to added.

To better understand your scenario, It is also highly appreciated if you
could generate a small sample containing your table structure, only one
subform included will be OK, to reproduce the situation on my side. You
could send the sample directly to (e-mail address removed) (Please
Remove the "online" as it's only for SPAM)


Thank you for your patience and corporation.

Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center

 

[Michael Cheng [MSFT]]

Hi Dwayne,

Thanks for your sending me the sample file

It seems the foreign key for the recordsource of the subform was set to an
AutoNumber and thus you were receiving this error because you were
attempting to assign a value to an AutoNumber field

I have change all AutoNumber to Number and everthing works smoothly.


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center

 

[DwayneConyers]

Hi Dwayne,

Thanks for your sending me the sample file

It seems the foreign key for the recordsource of the subform was set to an
AutoNumber and thus you were receiving this error because you were
attempting to assign a value to an AutoNumber field

I have change all AutoNumber to Number and everthing works smoothly.

That seems to work for all except one of the subforms, the one based on form
"handling."

The form never seems to initialize and clicking on it doesn't return an
error, just the windows "error" sound.

 

[Michael Cheng [MSFT]]

Hi Dwayne,

Thanks for your prompt updates!

subForm "handling" also seems working smoothly on my side. Have you
confirmed that Table classification_product_handling's autonumber was set
to Number instead of AutoNumber. Could you check it again?

BTW, please note that since AutoNumber no longer exists, you will have to
take care the Primary Key yourself, otherwise, you will not be able to
insert New Records.


Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center

 

[DwayneConyers]

I determined some code in the module was causing problems. I deleted the
code and it all works fine. Thanks!

 

[Michael Cheng [MSFT]]

Hi Dwayne,

You are welcome!

If you have any questions next time, don't hesitate to let me know. We are
always here to be of assistance!


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center