opening multiple forms

[Jason]

Hi,

I've a .mdb file with a lot of forms where i get recordsets through ado
from a external database.

The problem with the forms is that when a user has a particular form
open and another wants to open it, the following error occurs:

"The expression On Open you entered as the event property setting
produced the following error: .
* The expression may not result in the name of a macro, the name of a
user-defined function, or [event-procedure].
* There may have been an error evaluating the function, event, or macro."


Anyone has a solution for this problem?

 

[Guest]

It appears from your post that you have multiple users sharing the same front
end mdb file. The answer is - Don't Do That. Each user should have their
own copy on their own computer.

 

[Albert D.Kallal]

Check out the following article of mine, as it explains how to setup
ms-access to not have "one" problem become the problem for "all other"
users.

Check out the following:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm