Syncronise form (Current) record with a report print

[mondeoman]

I have a form that allows a central administrator to enter maintenance requests. I also have a report that shows the detail of a specific request. What I want to do is enable the administrator to click on a cmd button on the form that opens the report for that record only and then I want to be able email the report back to the user. I think it is about using a filter but I am not sure how to do it.

Form Name is: frm_Request_Detail
Report Name is : rpt_Support_Request_Print

Linked field is: Request_ID

Can anyone help please

 

[dhookom]

Your code might look something like:

Dim strWhere as String
Dim stDocument as String
stDocument = "rpt_Support_Request_Print"
[green]'Assuming Request_ID is numeric[/green]
strWhere = "Request_ID=" & Me.Request_ID 
DoCmd.OpenReport stDocument, acPreview, , strWhere

I don't work with emailing reports but there is lots of information if you google it.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mondeoman]

Many thanks I will try this.

Mondeoman