Report Macro

[BLD21]

access 2007,

I have a report that is using a query as the source. I am using a macro to run the query. What I can't figure out is how to run the report once the query is closed. I am trying to set this up in the macro. But the report runs prior to the query closing.

Any help is appreciated!
Bruce D.

[June7]

No need to 'run' the query, just open the report.

[BLD21]

To clarify,
I have a macro that runs a query that is used in a report. When the query runs I need to have the query open in datasheet edit mode. When I am done editing I want to close the query and then have a form open when the query is closed. I can't seem to find a way to wait until the query is closed before the form opens in the macro. Or can this be handled in the event procedure?

[June7]

You are doing data entry/edit directly in query? I recommend using form for this. Then code that opens form can control sequence of events and things don't happen until you want them to. For instance, open form with Dialog parameter and code execution is suspended until form closes. Can't do this with a query.

I don't use macros, only VBA. Easer to debug and more versatile.

[BLD21]

Yes, I agree. I should have thought about using a form earlier. It is working fine now.

Thanks for your help!