I have a subform in a form. The data for the subform is created using a make table query. I created a command button to close the form, run the make table query, then open the form up.
In the middle of the make table query process, it shows the run-time error 3211 saying it could not lock the table because it is already in use.
How do I fix this?