form error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Did you bind your forms to tables or queries? You should be using queries.
 
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.

sue said:
I have tried both. I get the same error.
Did you bind your forms to tables or queries? You should be using queries.
Click to expand...
[quoted text clipped - 3 lines]
Click to expand...
 
I had a record lock somehow. Thank you very much.

ruralguy via AccessMonster.com said:
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.

sue said:
I have tried both. I get the same error.
Did you bind your forms to tables or queries? You should be using queries.
Click to expand...
[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.
Click to expand...
Click to expand...

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
Click to expand...
 
Cool! Sounds like you got it resolved. Great news.

sue said:
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.
Click to expand...
[quoted text clipped - 7 lines]
Click to expand...
 
Back
Top