Macro

[Ielamrani]

Hi,
I am trying to run a macro when a form opens but I am having trouble. The Macro contains A Make table Query.
Here is the code I put on (ON OPEN):

Docmd.RunMacro "Macro1"

I am getting this message:
the database engine could not lock table 'tablename'because it's already in use by another person or process.

Thanks in advance

Ismail

 

[THWatson]

Ismail
Is the form based on the same table you are trying to make?

Tom

 

[Ielamrani]

No

 

[Ielamrani]

I did it.

Docmd.RunMacro "Macro1"
Docmd.OpenForm "Form1"

I added the second line to the code and it worked.

Thanks for trying

Ismail