Report Input Parameters
in [Reports]
|
From: pjscott on 12 Mar 2010 07:28 I'm using Sql 2000 and Access 2007. I have a form that I'm trying to print the current record that's displaying on the form. To keep the user from having to enter the MR Number and Date I've entered the following in the Report Input Parameters: @mrnum init=[forms]![frm_eeg_edit_new]![mrn], @eeg_date date=[forms]![frm_eeg_edit_new]![eeg_date] With these parameters when I press the Print Report button I receive a blank report. If I delete the parameters I'm asked for the MR Number and Date. When I enter the MR Number and Date the report prints the data. Can someone please give me an idea what parameters I need to enter to get this report to automate? Thanks for the help, Paul
From: Al Campagna on 12 Mar 2010 09:29 pjscott, Your open form record should have a unique identifying field value. For example a ClientID. With the form open, your query behind the report can use that form value as a criteria against the ClientID field. ClientID =Forms!frmYourFormName!ClientID That will filter the rpeort to return just the ClientID on the current open form record. OR Another method is to call that value in the OpenReport. Given that ClientID is a numeric value... DoCmd.OpenReport "rptYourReportName", acViewPreview, , "ClientID = " & ClientID -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "pjscott" <pjscott(a)discussions.microsoft.com> wrote in message news:A1FA2D28-199E-45DC-A925-DF4C4B99065F(a)microsoft.com... > I'm using Sql 2000 and Access 2007. > I have a form that I'm trying to print the current record that's > displaying > on the form. > > To keep the user from having to enter the MR Number and Date I've entered > the following in the Report Input Parameters: > > @mrnum init=[forms]![frm_eeg_edit_new]![mrn], @eeg_date > date=[forms]![frm_eeg_edit_new]![eeg_date] > > With these parameters when I press the Print Report button I receive a > blank > report. > > If I delete the parameters I'm asked for the MR Number and Date. When I > enter the MR Number and Date the report prints the data. > > Can someone please give me an idea what parameters I need to enter to get > this report to automate? > > Thanks for the help, > > Paul
From: Steve on 12 Mar 2010 13:31 I just spent several days trying to figure this same thing out. Below is the answer I found that worked perfectly for me. -On the form, in design view, use the wizard to create a "preview report" button. -Go to the button's properties -Go to "Event" tab -In the "on click" box, delete the macro the wizard created -click the "..." at the end of the "on click" box and select "code builder" when the option pops up -in the code builder input the following: DoCmd.OpenReport "YOURREPORTNAME", acViewPreview, , "[ID] = " & Me.ID -Replace YOURREPORTNAME with whatever the name of you report is, but keep the quotation marks. Replace both instances ID with whatever is the primary key for your table/query that feeds the form and report (keep the brackets on the first instance). Make sure that your VBA/Macros are enabled and try it out. Hope it works for you. "pjscott" wrote: > I'm using Sql 2000 and Access 2007. > I have a form that I'm trying to print the current record that's displaying > on the form. > > To keep the user from having to enter the MR Number and Date I've entered > the following in the Report Input Parameters: > > @mrnum init=[forms]![frm_eeg_edit_new]![mrn], @eeg_date > date=[forms]![frm_eeg_edit_new]![eeg_date] > > With these parameters when I press the Print Report button I receive a blank > report. > > If I delete the parameters I'm asked for the MR Number and Date. When I > enter the MR Number and Date the report prints the data. > > Can someone please give me an idea what parameters I need to enter to get > this report to automate? > > Thanks for the help, > > Paul
|
Pages: 1 Prev: Multi-Column Report Next: Macro to open up all 5 reports |