Multiple Queries in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run queries in a from. I need the first query to run, once
that query is finisehed a need the second and third query to follow. I want
to do this all with one command button. Any suggestions?

Thanks
Linda
 
Yes there is. My first query creates is a table query and the other 2 are
append queries. Therefore, the first query must run first.

Also, i;m having another problem when I run the Form which uses a subform,
it is replacing the data in table with the worng data.

Thanks
Linda
 
Yes there is. My first query creates is a table query and the other 2 are
append queries. Therefore, the first query must run first.
Click to expand...

You are doing a Create Table query and then appending data into it? Is that
right?
Also, i;m having another problem when I run the Form which uses a subform,
it is replacing the data in table with the worng data.
Click to expand...

I'm afraid I can't visualize what your problem is here. Remember that I
can't see your database, your tables or forms. I'm going to need a lot more
information.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
Hello Linda.
I am trying to run queries in a from. I need the first query to run,
once that query is finisehed a need the second and third query to
follow. I want to do this all with one command button.
Click to expand...

In the event procedure, you could use several statements like:
CurrentDB.Execute "NameOfQueryToExecute"
(provided that the queries are action or ddl queries)
 
Back
Top