I have setup a query where I require a Textbox to match a Field in a Query. Problem is the query is ran from a subform. I have two possible paths to subform. How do I set the criteria so that it takes a certain path depending on what the parent form is? I've tried using OR between the two but it'll give me a parameter prompt which I don't want.
Current setup paths:
[Forms]![TicketNO1]![Paw5]![OldTickNo]
[Forms]![Clients5]![Paw5]![OldTickNo]