Can I create a query using the results of a Macro?

  • Thread starter Thread starter hshepardjr
  • Start date Start date
The web interface cuts off the Subject line after about 50 characters so your
question looked like:

Can I create a query using the results of ....

Please keep the subject very short and expound upon it in the message area.

The big question is: What are the results of a macro? It almost has to be
something like a query running inside the macro to have results. Please
explain what those results are and how they became results.
 
The Macro displays query results based on selected criteria in a form. The
query results displayed are one of three queries. For example:

Macro criteria: If [Forms]![Pick]![Segment] = WIS, OpenQuery: "WIS Query"
If [Forms]![Pick]![Segment] = Count, OpenQuery: "Count Query"
If [Forms]![Pick]![Segment] = Summer, OpenQuery: "Summer Query"

I believe this can also be done through an If else statement in VBA but I'm
not sure how to create a query to call the recordsource in VBA.

Any help you can provide would be appreciated.

Thanks,
 
You must log in or register to reply here.

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

Query Returning Multiple Results 1
Use In() Expression as Query criteria with guts from Function 1
Can Data from a Table Field be Used to Create Queries Automaticall 1
Export query from a switchboard 7
Run query based on results of previous query using code 4
Combine Duplicates in Query 0
Why it deletes my query? 2
result query on a form 1

Back
Top