Search results

OK, that was it.....everything looks good now. I am going to transfer the codeing into a form, and add options to send out emails as well, but I wanted to get this part working first. Thanks! Paul

OK, placing the hard coded "254-770-77000" in the Me.Filter statement worked, and when it looped through all the different Service_Dealer_Loc records, it made each one have a pdf of "254-770-77000" So when I changed the MeFilter statement to: Me.Filter = "Service_Dealer_Loc = 'Me.OpenArgs'"...

Just getting back to this, I have added a Me.Filter statement in the ON Open property of the report, but have the same result. strArg = Me.OpenArgs Me.Filter = "Service_Dealer_Loc =" & Me.OpenArgs Me.FilterOn = True I have the Record Source Property of the report set for the query that...

I have not been able to pass my OpenArg in my DoCmd.OpenReport VB script correctly. What I have opens all my records, and sends a complete report to each file record, when I want individual pdf's for each group of Service_Dealer_Loc that I have. Here is what I am using: Sub pst() Dim db As...