Security

Hi everyone!

I have a user security system on my DB. I have several Forms. What can I do so that when people enter their names and passwords depending on the autorisation they got, the form that's made for them open. If possible... automaticly.

I.E. Admin => fmsAdmin
Research => fmsResearch
other => fmsOther

Generally I handle this by assigning users into a group and placing the group code are part of the user record. Then using a select case statements call up the correct screen for that group.