Form closing improperly

[muppetmad]

I have a custom switchboard that opens a data entry form based on several prompts (additional forms for user name date and password). Everything works correctly. When you close out of the data entry form, you return to the switchboard. If you click the button to open the data entry form again you are prompted for all new information and see the new user info. However, if while viewing the entry form as user "a" you call a report. When you close out the report and form and enter user data for user "b" you will see user "a" data as well as see user "a" information on the report. Even though you enter user "b" name and password. Help!

 

[Fear Naught]

You don't say how you are managing the security of your data. If all you are doing is giving access to the forms by username and password that does not secure the data.

Can you post your database for us to look at.

 

[muppetmad]

The data is controlled by SQL server the rights are controlled using AD groups. The purpose of the password is to first send the users to the appropriate form (Approver/User) then to only allow them access to their records. However, this problem is occuring for both user types.