Originally Posted by
rpeare
you don't need to call menus. let's say you create a form that allows the current user to change their PW, they would log into your database first. Once that information is captured (the userID) you can use that as a data source for your password changing form let's call it 'frmChangePW' and you want to open it you would create a button on your form main form, scroll down to the ON CLICK property of the button and type in
docmd.openform "frmChangePW"
You would just have to look up the current user's PW, make them type that in, and give them two other fields to type in their new password, check to see if the two new passwords match then perform an update to your users table.
I would recommend that your change pw form be unbound though that is up to you, it's just easier for me to conceptualize this way than a bound form.