yes the macro is opening some 15 queries, some are updating tables that are
later used by the main macro.

"Lynn Trapp" wrote:

Is your Macro opening those queries? Are you using multiple queries in your
final query that the form is calling?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

I created another form and now it works. I am not sure why the other form
did not work. I am using the same macro with the same queries. But, the
problem I have now is that all the queries I run are open. I would like
to
close all the queries and only show the end result, the report. How do I
close the queries?

Thanks

"Lynn Trapp" wrote:

when you say it doesn't work, what do you mean? Are you getting no
results?
Are you getting unexpected or "wrong" results?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

Thanks...it works. But now, I have another problem. When I specify
start
date of 1/1 and end date of 12/12 in the form, the queries do not
work.
But,
if I individually type the same info when I run the query by itself,
it
works. The fields in the form are formatted to short date. What
should i
be
doing?

Thanks

"Lynn Trapp" wrote:

Change [form] to [forms]

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
I have a form "specify dates" in which a user enters "startdate"
and
"enddate". I then run a macro which has about 15 update queries
depending
on
the dates. =[form]![specify dates]![startdate] and
=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate
and
enddate.
2. Some of the queries remain open. I would like the user to
only
see
the
end result which is a report.

Thanks for your help