one form - two ways to get there

[Rover]

I have form_A with a query as the record source. I call form_A from
form_B and use parameters (Invoice number) as criteria in the query
underlying form_A. I also want to call form_B from form_C using invoice
number. How do I pass the invoice number to the query? Or should I try
a filter on the form?

TIA

Jim

 

[Marshall Barton]

I have form_A with a query as the record source. I call form_A from
form_B and use parameters (Invoice number) as criteria in the query
underlying form_A. I also want to call form_B from form_C using invoice
number. How do I pass the invoice number to the query? Or should I try
a filter on the form?

If by "call form_A" you mean open the form. then get rid of
the criteria in the query and use the OpenForm method's
WhereCondition argument instead:

DoCmd.OpenForm "Form_B", , , "Invoice = "& Me.txtInvoice