Input Boxes Seem Locked on Access Sub Forms
I am using subforms in order to create an Options and Settings form within Microsoft access. If I open the subforms outside the confines of the main form, all controls work perfectly. Once contained within the main form, all the Text boxes on the Subform appear to be locked (although you can select the contents - all keystrokes are ignored). The subforms are NOT locked as the checkboxes on the same subform work fine.
The only other thing is that all the controls for these configuration pages are set on a Tab Control on order to easily switch between configuration pages...
I look forward to your assistance.
Kind regards,
Jed
The only other thing is that all the controls for these configuration pages are set on a Tab Control on order to easily switch between configuration pages...
I look forward to your assistance.Kind regards,
Jed
ASKER
The database is pretty much irrelevant as this is a subform on a tab control on a form - all subforms are unbound to any tables. It's really a question about form design and any constraints/weird behaviour rather than about the data. Also, the source code (when decompiled) is over 350Mb in size.
If it helps, this is currently what happens in Access 2007 but it is the same in 2010 so I'm fairly sure it is not a version issue and something inbuilt into Access.
Thank you.
Jed
If it helps, this is currently what happens in Access 2007 but it is the same in 2010 so I'm fairly sure it is not a version issue and something inbuilt into Access.
Thank you.
Jed
ok.. just zipped the file with only the relevant forms and codes.
What you are calling a "Main Form/Tab control",...looks like an tab control inserted into an Access "Navigation Form"
FWIW, ...I can edit subforms just fine whether the are inserted into Navigation forms, tab controls or standard forms.
So we still need to have you post a small sample of this database that exhibits this issue.
Or, FYI, and simple way to test this would be for you to create a scaled down version of this system and see if the issue persists...
FWIW, ...I can edit subforms just fine whether the are inserted into Navigation forms, tab controls or standard forms.
So we still need to have you post a small sample of this database that exhibits this issue.
Or, FYI, and simple way to test this would be for you to create a scaled down version of this system and see if the issue persists...
ASKER
I will see what I can do....
ASKER
Having taken this back to bare Access forms (got rid of all our own DLL/OCX files) the input boxes work fine.
Next step is to copy the Config form within the project and do the same I guess...
Jed
Next step is to copy the Config form within the project and do the same I guess...
Jed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have sorted the issue on my own.
upload a copy of the app.