Hello,
I have a re****t which I filter using the me.filter command in the
OnOpen event.
Me.Filter = "OrderID=" & Forms!variable_form_name![OrderID]
Me.FilterOn = True
I want to be able to open that re****t, filtered, from different
forms. How do I carry the name of the current form into the
'variable_form_name' part of the filter so that the re****t looks at
the current form to get the OrderID number and complete the filter?
I've tried pulling the form name through using
application.currentobjectname and putting it into a string, but it
didn't like that.
Many thanks,
Franc.