ACCESS gives error message when print 1 record from form into report

[SA]

This can happen in three situations:

1.) Go to the Tool -> Options menu item and in the resulting Options dialog
under Advanced, make sure that the default database open mode is "shared"

2.) Make sure that if you are entering data and then trying to open the
report using that last entered record that you issue a save command before
trying to spaun the report to make sure the record is flushed and the table
lock released. If you are using VBA you use code like:

DoCmd.RunCommand acCmdSaveRecord
Docmd.OpenReport, "MyReport", acViewPreview, , "[CustomerID] = " &
Me!MyForm!CustomerID
--
Steve Arbaugh
MS Access MVP

3.) If you'd had your form or table opened in design mode, that places a
"lock" from time to time on the underlying table

"ACCESS" <anon...@discussions.microsoft.com> wrote in message
news:EEB4D48A-D98C-45DE...@microsoft.com...
> I get an error message when I go to print a single record from a form into
a report. The error message states that the table is already in use by
another. How to correct?