Is there a way to prevent a form from updating its content dynamically?

[Inkognito]

Hi Again

I was wondering if anyone knew of any way to prevent a form from updating its content against the tables dynamically?

I have some subroutines that check what values the fields have, and deactivates some of the fields based on the values.
(Every field that is not "0" is deactivated with on current).

The problem is that when two or more users are using the database, and one of them changes one of the fields, this changes suddenly appears in the other users' form as well.
This as i huge problem, as the fields doesn't get deactivated when the data appears in this way.

I would really need some way to prevent this from happening, so that the only time the form would update its info is when the record is changed or manually updated.

Any help appreciated

 

[JamesMcS]

I'd be interested to see a solution to this problem, I don't think there is one is there? Unless you were to lock the record out when the first user opened it.

 

[DCrake]

As a matter of interest do both users have their own front end? as each of them will have their own OnCurrent Event.

 

[Inkognito]

There is no front end / back end, it's all in 1 file that is stored on a server. The users tunnel inn with remote desktop in multiple sessions. Or atleast that how I imagine it will be, I'm currently in the testing-phase of the DB.