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 Config Form at RuntimeThe 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...
The Config Form at Design Time showing the Subform and Tab ControlI look forward to your assistance.

Kind regards,

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
not easy to post comment without seeing the db.

upload a copy of the app.
JedNebulaAuthor Commented:
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.

Rey Obrero (Capricorn1)Commented:
ok.. just zipped the file with only the relevant forms and codes.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Jeffrey CoachmanMIS LiasonCommented:
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...
JedNebulaAuthor Commented:
I will see what I can do....
JedNebulaAuthor Commented:
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...

JedNebulaAuthor Commented:
OK - I have sorted this one.

It was all to do with the Treeview control which was being used to select the pages (this is one of the vbAccelerator Treeview controls). I was using the 'NodeClick' event to select the tab the desired subform was on. I found that bypassing the treeview and putting a temporary button on the form to do the same job allowed the Textboxes to remain unaffected (leading me to beleive it was the Treeview that was the issue). Instead of the NodeClick event I used the MouseDown event instead (I know I should use the MouseUp event but this has never worked in the vbAccelerator Treeview control) and this allowed the subform to be selected and the text boxes to work just fine.

Thank you for your suggestions though.

Kind regards,


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JedNebulaAuthor Commented:
I have sorted the issue on my own.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.