Run Time Error '2046'

[Mary]

Hello,

I'm getting a "run time error 2046 - The Command or Action 'OutPutTo' isn't
available now"... when I try to run a query off a form that outputs into
Excel. This has worked fine before and I'm not sure what could have changed.
I'm using the same code on a different form and have no problem. It doesn't
happen when I'm in design mode of the db, only when using it "live" as the
user would see it.

What could be going on?

Thanks,

Mary

 

[Rob Oldfield]

It may well be due to some kind of timing issue. Could you post the code
that you're using (i.e. the entire routine, not just the line that's going
bang).

It might also be useful if you also post the 'same' code that's working from
the other form.