Run a Query from a form

P

Patrick

We are currently setting up a Report Request Database. I am saving all the
queries with the number that is generated after the report request is
submitted. I would like to open a form put that number in a field, click a
button and have the query open in preview mode.

I would also like to then have another button that will export the query in
excel still using the "Request Number" I put in the field on the form.

I think this is possible, but my knowledge of VBA is very limited and I am
having trouble. I would appreciate any help that anyone can give.

THANKS!!!!
 
Top