469,607 Members | 1,882 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,607 developers. It's quick & easy.

Shortcut menu action syntax - on a control

I have successfully added shortcut menus to Forms but I am now having
difficulty when I attach a shortcut menu to a text control. I have a
shortcut menu entitled 'CalendarEntries' with one command whose 'On
action' is =showAbsence().

The control is on a Pop up Form called 'Calendar' that has a function:
Public Function showAbsence()
......
End Function

The Shortcut Menu Bar property of the control is set to
'CalendarEntries'. The Shortcut Menu Bar property of the Form is not
set.

When I right click the control I get the error:
"The expression you entered has a function name that Microsoft Access
can't find"

If I change the On action to =Forms![Calendar].viewAbsence() the
correct function is activated but when it reaches its End statement, I
get the error:
"The expression you entered contains invalid syntax"

If I change it to =Forms![Calendar].viewAbsence ,it runs correctly
but three times!!

I have just noticed that the first version of the 'On action' (the one
I expected to work) does in fact work if I remove the Pop Up property
from the Form.

So how do I set up a shortcut menu on a control on a Pop up Form?
Oct 17 '08 #1
0 1512

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Salad | last post: by
reply views Thread by Marcel | last post: by
2 posts views Thread by Jim Devenish | last post: by
3 posts views Thread by KennethLundin | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.