linking reports though code

  • Thread starter Thread starter jln via AccessMonster.com
  • Start date Start date
J

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.
 
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
 
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.
Click to expand...
Click to expand...
 
Back
Top