A
Amy E. Baggott
I have a dialog box that provides parameters for a query that is then used to
update one table and append records to another. If I try to use the query
for an Update or Append query, I get an error message saying "Operation must
use an updatable query." In the past when I have run into this, I have been
able to use VBA code to open the query and my tables as recordsets, use
"Seek" to match up the records and update the information in VBA code.
However, this one is giving me a "Too few parameters (expected 4)" error.
The form will open the query just fine, but if I try to open the query as a
recordset, it balks. The query in question is very complex and is fed by a
number of subqueries reflecting our rather complex method of awarding
priority points to our exhibitors, so I don't think I could simply reproduce
the whole thing in code. Is there a way to get around this problem? I need
to run this as soon as possible so that I can post the show to history and we
can start working on the next one. TNX
update one table and append records to another. If I try to use the query
for an Update or Append query, I get an error message saying "Operation must
use an updatable query." In the past when I have run into this, I have been
able to use VBA code to open the query and my tables as recordsets, use
"Seek" to match up the records and update the information in VBA code.
However, this one is giving me a "Too few parameters (expected 4)" error.
The form will open the query just fine, but if I try to open the query as a
recordset, it balks. The query in question is very complex and is fed by a
number of subqueries reflecting our rather complex method of awarding
priority points to our exhibitors, so I don't think I could simply reproduce
the whole thing in code. Is there a way to get around this problem? I need
to run this as soon as possible so that I can post the show to history and we
can start working on the next one. TNX