Query Critera w/ two Paths

[Mike4172]

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]

[June7]

Don't think you can.

What do you mean 'query is run from subform'? You are opening a query object? I don't open queries, I open forms and reports based on queries. I use VBA code to build filter for the form or report and pass the filter to form/report in WHERE CONDITION argument of DoCmd.OpenForm (or OpenReport). Example:

DoCmd.OpenForm "formname", , , "TickNo='" & Me.OldTickNo & "'"

[Mike4172]

In Subform I'm search for records with same ticket number so I can crate a label. So I have a Text Box and when the ticketnumber matches one in the Table, it'll grab the data and print it to a label. The subform is on two seperate parent forms is the issue I'm running into.

[June7]

The label is a report printout? Use the VBA method to pass filter criteria to the label report.

[Mike4172]

Ok, please explain.

[June7]

Thread is already marked solved, did you resolve?

Use VBA code in some event, perhaps button click, behind the form. Example code in my previous post.

[Mike4172]

Yes. I looked up how to do it from the command and it works good. Thanks for the pointer.