Hello,
I have a form with a combo that is used as criteria to a queries.
I would like these queries to be used as record source of a standard reports which should then be attached to an email in pdf format.
Users will select the query from the combo and the report generated into pdf. I would like some help to obtain something similar (sorry about the code, but it's just to give an idea)
If Me.mycombo = "Clients" Then
myreport.RowSource = " myquery"
DoCmd.SendObject acReport, "myreports", "PDFFormat(*.pdf)", "", "", "", "Hello", "", True, ""
Thank you for any help.
I have a form with a combo that is used as criteria to a queries.
I would like these queries to be used as record source of a standard reports which should then be attached to an email in pdf format.
Users will select the query from the combo and the report generated into pdf. I would like some help to obtain something similar (sorry about the code, but it's just to give an idea)
If Me.mycombo = "Clients" Then
myreport.RowSource = " myquery"
DoCmd.SendObject acReport, "myreports", "PDFFormat(*.pdf)", "", "", "", "Hello", "", True, ""
Thank you for any help.