Changing visible and enable properties in a multi-user environment

[Gregs List Acct]

I'm programmatically changing .visible and .enabled properties on various
form fields based values entered in other fields. This works great for a
single user, but the moment a 2nd user opens the form, they're instance is
subjected to whatever the last .visible and .enabled properties were set.

Is there a way to keep the .visible and .enabled property changes limited to
the scope of a single user? Is there a better approach to handling this?

 

[Douglas J. Steele]

Sounds as though your users are sharing the same database. That's a recipe
for disaster.

Split your application into a front-end (containing the queries, forms,
reports, macros and modules) and a back-end (containing the tables and
relations). Only the back-end should be on the server. Each user should have
his/her own copy of the front-end, ideally on his/her desktop.