Hi

Just need a pointer on this one i think.

I have a parameter query, that I use to run a report, so when I run the report I'm propted for a user id.

From the user record form I have a button to run the report.

What I want to do is pass the user id into the report, and not have the prompt.

Is this easy to do.

Andy G

Hi

This is quite easy to do.
All you have to do is change your parameter to refer to your form.
Example [Forms]![Users]![UserID] and that´s it

-vemaju

This will only allow you to use this query from the one form. If you use it for other forms/reports, then remove all criteria from the query and pass it directly from the form. Let us know if you need to know how to do that.


mmcdonal

Thanks Both

The report is only run from the one form so vemaju's solution will work.

I can't help thinking that sendng the criteria from the form is a 'better' way.

Yes I would like a pointer as to how to do it.

Andy G

On your form's open report button, you'd have something like

DoCmd.OpenReport "Your Report Name", acPreview, , "[Your Numeric Field] = " & Me.txtYourNumericField

DoCmd.OpenReport "Your Report Name", acPreview, , "[Your Date Field] = #" & Me.txtYourDateField & "#"

DoCmd.OpenReport "Your Report Name", acPreview, , "[Your Text Field] = '" & Me.txtYourTextField & "'"

Place your report's real name in "Your Report Name", place your field's real name in [Your Field], and place the name of the textbox that is bound to your field in Me.txtYourField. The first line is for the case where your field is a number, the second is if your field is a date, and the third is if your field is text, respectively.



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks Greg

Works Ok, once I figured out to remove the parameter from the query.

You don't know of an easy way to take the contents of the report and stick them in the email body, rather than the attachment.

Andy

Sure, to place text in the body of the e-mail instead of the attachment, look up help for DoCmd.SendObject method.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division