I have set up shortcut menus on many form successfully.
However, for the first time, I am trying to set one up on a subform.
In the 'On Action:' when customising the menu item I have:
=Forms![OrderDetails].showAvailability()
showAvailability is a public function in the module of the form
OrderDetails. This follows the working pattern for all other forms.
When I right click the item in the shortcut menu, I get the error:
"The object you referenced in the Visual Basic procedure as an OLE
object isn't an OLE object."
In this case OrderDetails is a subform of the form "Orders".
I note that if I open the Form OrderDetails on its own (as an
experiment) the right click works but not when it is opened as a
subform.
Should I amend the action to reflect this and if so, how?