linking reports though code

[jln via AccessMonster.com]

What i have is 6 reports attached to buttons that have the user enter the
INV# when pressed this runs a query that generates each report. What i need
to have it do is enter the inv# number once and all 6 reports print. Also all
six reports run a different query. So any ideas.

 

[Guest]

Put a text box on your form to enter the inv#.
Use the Where argument of the reports to filter the data for the report:

strWhere = "[inv#] = " & Me.txtInvNo
DoCmd.OpenReport "MyReportName", acNormal, ,strWhere

 

[jln via AccessMonster.com]

Ok what i get when i use the code below is still the popup box asking for the
inv number. Could i put the value from the text box into say Dim INVtext as
Interger and have that populate my strwhere value?

Hey thanks for the help again

Put a text box on your form to enter the inv#.
Use the Where argument of the reports to filter the data for the report:

strWhere = "[inv#] = " & Me.txtInvNo
DoCmd.OpenReport "MyReportName", acNormal, ,strWhere

What i have is 6 reports attached to buttons that have the user enter the
INV# when pressed this runs a query that generates each report. What i need
to have it do is enter the inv# number once and all 6 reports print. Also all
six reports run a different query. So any ideas.