Exporting to word or excel makes qeury disappears

S

Stardust22

Hi!
I'm working in a access database that someone else have created and I have
never worked in access before. There is a very complicated SQL-query that
makes it possible to filter before you export the information to word, but
when I do this the SQL-query disappears, the question window becomes blank.
What can be the problem? Is this common in access?

There is a form where the user can write parameters in combination boxes and
with a command button. When you click on the button the query uses the
parameters to chose which posts should be exportet. The command button was
created with the guide (report operations=>send report to file.. and so on).
The query do not disappear every time, but often, which is very confusing..
Thanks in advance!
 
Top