Open Report after query

[holta]

I am trying to open a report after a user inputs parameter job ID this is a number, in a form. Once this is entered it references a query and pulls all of the people that have applied for the job id. Instead of the query opening up I would like for the report to open. Right now the query opens and then the report ask for a parameter before it will open. Any suggestions?



Thanks,

Aaron

[June7]

I use only VBA, not macros. Use WHERE argument:

DoCmd.OpenReport "reportname", , , "fieldname=" & Me.formcontrolname.

[holta]

I should have specified this in the post, I am a newbie when it comes to VBA and really access in general. When I add this command to the form on the button it doesn't do anything. When you say fieldname which name are you referring to, the one from the table or the query?

Thanks,

Aaron

[June7]

Fieldname that is included in the RecordSource of the report being opened, like JobID. And use your control name in place of the generic alias in my example.

The code must be put in the VBA editor. Select [Event Procedure] in the Click event property of the button. Double click the ellipses (...) and this will take you to the procedure in the VBA editor. Type code there.