Passing a value from a form to a report in Zccess 2003

[marsha D. Carpenter]

I have a form that uses the OpenReport method to open and run one one of six reports. For each of the six reports, I need to pass the report module the date of the data to be contained within the report. How can I do this, if I put the date in the openargs argument of the OpenReport method, how do I retrieve it in the report module? I know this is really simple and silly. Please advise!
Thanks:

 

[shadow9449]

I have a form that uses the OpenReport method to open and run one one of six reports. For each of the six reports, I need to pass the report module the date of the data to be contained within the report. How can I do this, if I put the date in the openargs argument of the OpenReport method, how do I retrieve it in the report module?

Marsha:

The most common way to do it is have a form (let's call it frmForm) with a text box, (let's call it txtDate). The user types the date in the box and clicks OK or something, which launches the report. The filtering can be done by referencing the date, using something like this [forms]![frmForm]![txtDate]

Get it?

SHADOW

 

[marsha D. Carpenter]

Got IT!

Marsha:

The most common way to do it is have a form (let's call it frmForm) with a text box, (let's call it txtDate). The user types the date in the box and clicks OK or something, which launches the report. The filtering can be done by referencing the date, using something like this [forms]![frmForm]![txtDate]

Get it?

SHADOW

Thanks! I'm just learning to use this forum as well!

 

[marsha D. Carpenter]

Compile an Access DB - Not responding in task list

I am attempting to compile an .mdb file which has six reports, one form, six queries, two tables and a global module. The .mdb was initially created in Access 2003, I took it home and worked on it using Access 2000. When I first attempted to compile the program in Access 2003 it told me I needed to convert 2000 to 2003 so I did. Now I am trying to compile to a .mde and my system locks up. Please advise