I have created a form and report that uses two sub-forms. When I go to print the current record I receive the error message "You tried to lock table '~sq_drptStaffProfiles~sq_dfrmProfileSub1 while opening it but the table can't be locked because it is currently in use..." I imagine this has something to do with the report having the sub-forms on it. What can I do to print an individual record from my form? I have reviewed the MS article on Printing an individual record and it is not of use. Thanks!

This type of locking issue is usually caused by using a table as the recordsource for multiple open objects. Try changing the recordsource of the report to a query.

Thanks! That worked.