Password to open a form

M

mgm

I have created a music collection database. When the .mdb file is opened, a
main form opens with command buttons set to open other forms. i.e. View
Album titles, View Uniquesongs.
There is a command button to open another form that also has command
buttons to open underlying tables of the database.
I would like to have the Database Admin openform command button that appears
on the Main form, to also activate a password dialogue box. I don't want
all users of the database to be able to alter the underlying tables. What
is the best way to accomplish this.
 
Top