form error

[sue gray]

Help! I am using a command button from a subform to open form and I am
getting an error. It says "the table tbleActivityNote is already opened
exclusively by another user, or is already opened by the user interface and
cannot be opened programically". I have this same concept on 3 other forms
with now problems. THanks for any ideas.

 

[ruralguy via AccessMonster.com]

Did you bind your forms to tables or queries? You should be using queries.

 

[sue gray]

I have tried both. I get the same error.

Did you bind your forms to tables or queries? You should be using queries.

 

[ruralguy via AccessMonster.com]

Are you trying to open the same table as the MainForm is bound to? What kind
of Record Locks do you have set on the Data tab of both MainForm and SubForm.
Use queries on both.

I have tried both. I get the same error.

Did you bind your forms to tables or queries? You should be using queries.

[quoted text clipped - 3 lines]

 

[sue gray]

I had a record lock somehow. Thank you very much.

Are you trying to open the same table as the MainForm is bound to? What kind
of Record Locks do you have set on the Data tab of both MainForm and SubForm.
Use queries on both.

I have tried both. I get the same error.

Did you bind your forms to tables or queries? You should be using queries.

[quoted text clipped - 3 lines]

cannot be opened programically". I have this same concept on 3 other forms
with now problems. THanks for any ideas.

 

[ruralguy via AccessMonster.com]

Cool! Sounds like you got it resolved. Great news.

I had a record lock somehow. Thank you very much.

Are you trying to open the same table as the MainForm is bound to? What kind
of Record Locks do you have set on the Data tab of both MainForm and SubForm.

[quoted text clipped - 7 lines]