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?

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!

LVL 14
Bill RossProgrammerAsked:
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.

Dale FyeOwner, Developing Solutions LLCCommented:

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.
Bill RossProgrammerAuthor Commented:
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....

Dale FyeOwner, Developing Solutions LLCCommented:
There is nothing obvious there that makes any sense.  I've looked at the data types, the actual data, everything seems to be the same.

If you open the CorrespHistForm, change the data source to the Payment table, and the control source of your textbox to [PName] and then save that as a new payment form, you get the full set of options that you get with the CorrespHistForm.

But for the life of me, I couldn't tell you why.  There is probably a form property in there somewhere that I keep missing that is causing that problem.

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
Jeffrey CoachmanMIS LiasonCommented:
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?)

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.