Run-time error ‘3211’

[DaveL]

I am trying to populate a subform in my form using a make-query based on the value selected in a combo box on the form. When the value selected in the combo box changes, I want to change the data in the subform. I am then allowing the user to select or deselect individual records on the subform for printing.

Every time the make-query runs, I am getting a Run-time error '3211' telling me that it couldn't delete the file because it is already in use by another user.

Can anyone give me ideas on how to correct this error or on a different way to solve this problem?

Thanks!

 

[thwingr]

Try deleting all records and then appending new records. Access won't let you delete a table you have open in a subform.

 

[DaveL]

thwingr,

That did the trick. Thanks for the tip!

DaveL