ReturnsRecords problem?

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have code that runs various queries. The only two I have a problem with are
the two that use select queries as input. When each runs, the results of the
select query are displayed, which is NOT what I want. I just want the darn
things to RUN.

In the searching I've done, it LOOKS like what I want is the ReturnsRecord
property.

My problem? Am I correct? And how do I use it?

Thanks so much in advance.

Tom
 
Tom,

It sounds like what you want to do is run an action query to create or
update another table. Is that the case? If so, you can use the you can use
the following technique, where you replace "qry_Append" with the name of
your query (not sure whether this requires a reference to DAO or not).

CurrentDb.QueryDefs("qry_Append").Execute
 
Back
Top