Susan Zeller
szeller at cce.umn.edu
Tue Feb 25 13:03:40 CST 2003
Julie, Bring up the properties sheet on the report and then in the Input Parameters property, reference your variable and your field such as: @Term = Forms!frmWiz!subcrit!txtParam_Term, @May = Forms!frmWiz!subcrit!txtParam_May Note that I have two varialbes, @term and @May that my sproc needs so separate by comma. Also, the textbox I'm referencing is on a subform so that's why I have Forms!FormName!SubFormNAme!TextBoxName. Write a stored procedure to use as the record source of the report. Note that it's easier to set the recordsource of the report to your sproc in the on_open of the report. Then, on the report itself, in the properties window, put the table name in the recordsource slot. That way you can see your field names for report design. --Susan -----Original Message----- From: Julie Reardon-Taylor [mailto:prosoft6 at hotmail.com] Sent: Tuesday, February 25, 2003 11:04 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Sending parameters to a report Susan, I am trying to do the same thing right now, referencing a field on a form as a "filter" for my report. Are you placing the input parameter in the report? Julie Reardon-Taylor PRO-SOFT OF NY, INC. www.pro-soft.net _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com