Linking a Form to another Form Problem

[adrian007uk]

Hi i am having trouble linking two forms together. I am getting the error
message:

"The table '[My Table Name]' is already opened exclusively by another user,
or it is already opened through the user interface and cannot be manipulated
programmiticaly".

I have found this has something to do with me locking the records in the
forms. I want the records locked in both forms to prevent editing the data
(there is another way to do this in my database). Is there any way around
this problem?

Thanks

Adrian

 

[TonyT]

Hi Adrian,

You can set the form to not Allow Edits, or Additions/Deletions etc from the
Properties box without having to resort to record level locking on the table
itself. Also you have Locked and Enabled properties for each individual
control on the form to further restrict data changes on a form where you do
allow (limited) edits.

Using record level locking is not a good approach for most day-to-day forms,
especially in a multi-user environment. Nobody would get anything done and
would be cursing you constantly!

TonyT