Subform "greyed out" problem

paulml

The egg was first!
Local time
Today, 19:56
Joined
Jan 5, 2010
Messages
15
Good morning everyone
We have been using Access 2003 for 8 years and we're now updating to 2013. Wow, it's a big leap!
I've sorted out a few issues but I'm struggling with something......
When our users, place a new order, a macro runs to open up a "New Order" form. This form contains a subform (datasheet) that displays the available stock to the user and allows the users to select quantities and prices etc.
This has worked fine for the last 8 years but now, in 2013, the subform is inaccessible and greyed out.
We have other "New Orders" forms for different products and customers and these seem to work ok. I've compared the properties of the working subforms with the non working one and cannot see any difference.
If anyone has any idea why this might be so, I'd be grateful for your input.
I know it's likely to be a silly little thing but it's frustrating so any help would be great.
Thank you in anticipation.
Paul
:)
 
As a further thought to my problem here, the subform is normally focused in a tab order. Instead of the normal tab order taking the focus to the subform, it takes it to the Form Tools, Datasheet tab above the ribbon. Although I can see the subform headers the actual datasheet is greyed out and not accessible.
I'm not sure if this info will help anyone to assist my plight?
Thanks a lot.
 

Users who are viewing this thread

Back
Top Bottom