DB Engine unable to run querie

[Adrianna]

I have a button in one of my forms that runs a macro. This macro runs the a query to limit data needed for a report. The problem is that the Form that the Marco is on, is running from the same table that the query is trying to use.

When I RUN the marco outside of the report, that Macro does what it's supposed to, but when I run the report from the form, I'm getting the error:
Database Engine could not lock table because it is being used by another user or process. Well, I'm creating it so no one else is using, and I understand that the Form is using the same table, but there has to be a way to launch the report. Ive even tried adding a close feature to the Macro, but it didn't seem to work. Can anyone help. It's really holding up my progress.

THanks!

 

[Pat Hartman]

Try saving a copy of the query and using the copy as the recordsource for the report. The conflict is probably that Access can't run the same query for report and the form simutaneously.