Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[Tim J]

I am getting run-time error 3008

'The table (TableName) is already open exclusively by
another user, or it is already open through the user
interface and cannot be manipulated programmatically.'

I get this when trying to open the form in code from any
other form that has a record source.

If my current form has no record source then the other
form opens fine.

here is the code

Forms![Back].[MainCheck] = False

DoCmd.OpenForm "Cands", acNormal, "", "", , acNormal

DoCmd.Close acForm, Forms![Back].[CrntFrm]
Forms![Back].CrntFrm = "Cands"

The error occurs on the form open line.

Again, I only get the error when running the code from a
form the has a record source, else it works.


Any Ideas?

TIA,
TimJ

 

[Ken Snell [MVP]]

What is the Record Source of the "Cands" form? Is it the same as the form
that is opening it? Or is it using a table that is also in the opening
form's RecordSource?

Are any of the forms' Record Locks properties set to All Records or Edited
Record? Set them to No Locks instead.