Hi,
I have a form with continous subform, for which I had added custom right-click context menu.
In this context menu I'm opening 2nd form (with subform also). That form should open in same record as I right-clicked the menu in field of previous form. Context menu is set for text field in continous subform.
This doesn't work, since code for opening form is launched from a module and not from 1st form Itself - so Me! can't work :
What can I do to fix this ??Code:DoCmd.OpenForm "YourFormName", , , "[NameOfFieldFromDataSource]='" & Me![NameOfFieldOnFormOpeningFrom] & "'"
I'm really struggling with this one, any help much appreciated !!!