one form - two ways to get there

  • Thread starter Thread starter Rover
  • Start date Start date
R

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
 
Rover said:
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?
Click to expand...


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
 
Back
Top