Bill Ross
asked on
MS Access two Forms with Different Right Click Menus
Hi All,
I have 2 forms in an Access 2007 db that have different right-click menus. Anyone have any idea why?TestDB.zip
See TestDB.accdb (access 2007 format) attached?
Right click on either form and compare to the other. You'll see what I mean.
Thanks in advance!
Bill
I have 2 forms in an Access 2007 db that have different right-click menus. Anyone have any idea why?TestDB.zip
See TestDB.accdb (access 2007 format) attached?
Right click on either form and compare to the other. You'll see what I mean.
Thanks in advance!
Bill
ASKER
Hi Dale,
That's what I'm referring to. Both fields are text boxes yet they have different sort and text filter menus.
I have no idea why. These are subsets of 2 different forms that have many more controls. All text boxes work the same within each form but the forms but are different between the forms. Forms tabs are the same.
Go figure....
Bill
That's what I'm referring to. Both fields are text boxes yet they have different sort and text filter menus.
I have no idea why. These are subsets of 2 different forms that have many more controls. All text boxes work the same within each form but the forms but are different between the forms. Forms tabs are the same.
Go figure....
Bill
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is your question why,
...or is your question that you want one menu instead of the other?
If you simply create two new continuous forms, then both have the same menus (with the standard filtering options)
If you don't want the filtering options, ...then make a copy of "PaymentForm" and change the recordsource of the form and the control source of the textbox to match those of CorrespHistForm, ...then this new form will not have the filtering...
Like Dale, ...I don't know the "Why"
(Perhaps one form was created with an older version of Access?)
JeffCoachman
...or is your question that you want one menu instead of the other?
If you simply create two new continuous forms, then both have the same menus (with the standard filtering options)
If you don't want the filtering options, ...then make a copy of "PaymentForm" and change the recordsource of the form and the control source of the textbox to match those of CorrespHistForm, ...then this new form will not have the filtering...
Like Dale, ...I don't know the "Why"
(Perhaps one form was created with an older version of Access?)
JeffCoachman
I opened each of these forms and right clicked on the forms tab and the options presented were the same (Save, Close, Close All, Form View, Design View).
However, when I click into the only control in each of those, I do get different options presented when I right click. Keep in mind, that all shortcut menus are context sensitive, so that certain controls (options) are visible and enabled only during certain circumstances.
Although I'm pretty good with commandbars, see my articles, I have never been able to locate any documentation regarding the logic used to determine what options are available in a particular "context". My particular pet peeve is the absense or presence of checkboxes when you right click on a column header in a datasheet view.