The database engine could nnot lock table because it is already in use

[kilburfi]

I have a drop down box on a form that, dependent on what is chosen runs a query which creates a new table ("POWER PRICES Query Table 1") via a Macro. It then displays the results in a sub-form.

If you then use the drop down box again to change the selection I get the error message

"The database engine could not lock table 'POWER PRICES Query Table 1' because it is already in use by another person or process."

I have a clear button on the screen which runs VB code to clear all fields for a new search which works fine but I would also like to be able to just change the choice in the drop down box and for it to requery.

 

[kilburfi]

Panic over - I set the datasource of the subform to "" via an expression before running the rest of the Macro. Works fine now.

 

[ootkhopdi]

Panic over - I set the datasource of the subform to "" via an expression before running the rest of the Macro. Works fine now.

Sir
how can u do this

pls tell me ..
i m also facing this problem
i have a table which related with subform which gives result

how can i solve this prob.