close form code not releasing recordsource..

[dmeehanjr]

i have a temp table that is recordsource for a form, and I want to set command button that rebuilds the temp table and re-opens form.

When I close the form by code or Macro, get runtime 3211 error that says 'table in use, cannot be deleted'.

When I close the form by x-ing out, then run the query - it runs fine.

(also added a 10 second pause, in case form needed more time to close out and release locks)



not sure how to get around this?

[NTC]

well assuming your code to close the form, does indeed precede the code that deletes the table object - then this should not be happening.

if it also seems that your form takes an unusually long time to close in manual mode - then I would suspect that form and consider whipping up a replacement if it isn't too much work.

but otherwise try to separate the two actions. remove the delete table code so that the action is only to close the form. Put the delete table code in front of the make new table - so it is deleting the table just before it makes a new table. that will probably work.