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
LVL 14
Bill RossAsked:
Who is Participating?
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 FyeCommented:
Bill,

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.
0
Bill RossAuthor 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....

Bill
0
Dale FyeCommented:
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.
0

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?)

JeffCoachman
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.