Right-click popup in a subform

[GraeagleBill]

I have a right-click popup menu I want to "service" with a function that I'd like to have defined in the code-sheet of a "continuous" subform, " DonationSubform". Access complains that it can't find the function UNLESS I place it in the code sheet of the parent form. That would be okay except I can't seem to find out how to pass the function the record ID of the record upon which the right-click occurred. The popup "Action" expression is "=MoveDon()" and I've tried "=MoveDon([FamDonID]). The latter being the record ID of interest to the purpose of the function. With the function being defined in the parent, I've tried to reference "FamDonID" using Forms!DonationSubform.Form!FamDonID, but Access complains that it can't find the subform at the time the subform and all of its recordsource is being displayed.

Any of this make sense?

The whole point is to gain access to the current value of "FamDonID" at the time the popup menu is triggered.



BTW, while created in A2000 or A2003, popup menus are supported in later versions of Access, but one can't create them beginning with ribbons in A2007.

[June7]

I always give subform container control a name different from the object they hold, like ctrDonation.

Try:

Me.ctrDonation!FamDonID

[GraeagleBill]

One of the 1st things I discovered when I opened the covers on this caper was the container name being the same as the sub-form name. A lot of references in code, so I'll fix it VERY CAREFULLY. (Probably easier to change the name of the form, but we'll see.)

Me.DonationsSubform!FamDonID works perfectly.

I'll go with "this" solution, but I still can't understand why the Public function isn't found when it resides in the code sheet of the sub-form.

[June7]

AFAIK, procedures behind forms are only available to those form, regardless of the 'Public' declaration, unless you prefix the procedure call with the form qualifier

Call Forms("SampleManagement").LabReport(strLabNum, "Transfer")

or in this case through the subform container

If Me.tbxSet Like "*1*" Then Call Me.ctr1.Form.SaveData

[GraeagleBill]

I'll play with this a bit more tomorrow. I thought with the right-click action being executed on the sub-form that the function invoked could be contained in the code sheet of the sub-form. Doesn't that satisfy what you say "Procedures behind forms are only available to those form"?

[June7]

Yes, seems to me it should work but I've never used customized right-click. I know that the intrinsic right-click recognizes value of the control where the click occurs.

I do have code in the DblClick event of a subform.

Perhaps the issue is that right-click is not a form event, at least it is not listed on the Properties Sheet.

[GraeagleBill]

I'll comment the function code in the parent so it's clear what's happening.

I considered using the double-click event to provide the needed function, but that would create a significant inconsistency for the user, as the double-click action throughout the app imply the same functionality AND right-click popups are used consistently to present options pertaining to the current record in continuous forms.

Thanks,
Bill