Can I set a parameter for a query in VB?

K

KimC

I want to send a report to the email addresses I get from qry1. How do I
pass each address to the report qry2 as a parameter through VB. I have the
parameter qry2 for the report working fine, it prompts me for an address. In
VB I want to get this parameter value from qry1 so the report will run
without being prompted for it. I think I'm having a syntax problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prompt form launching report with subreport 8
Grouping by month 2
Best way to show an update 3
Total percentage for a query 0
Summary and Details need to combined in a query 0
Office 10 Crosstab query with Parameters 0
UNION Query with Join 3
parameter prompt problem 2

Top