I have a generic log-in form that I want to use to to grant access to a number of desired 'edit data' events which are called via 'buttons' from a master form. Some of the MasterForm event buttons do not require password access and some do.
Due to the nature of the app, the password is hard coded into the frmLogIn vba code. If the password is correct, then I want pass a TRUE/FALSE value [PswdOK] back to the calling event VBA and then open (or not) the relevant 'editing' form.
I can't seem to get the [PswdOK] value to pass from the frmLogIn object back to the VBA code in the calling event. I've tried to define the PswdOK as a Public variable and then modify it within the Private frmLogin VBA code but I guess I don't know how to do it correctly
There's probably an easier way to do this. Any other suggestions would be welcome.
I'm sure you can tell I'm new to this... MBA
Due to the nature of the app, the password is hard coded into the frmLogIn vba code. If the password is correct, then I want pass a TRUE/FALSE value [PswdOK] back to the calling event VBA and then open (or not) the relevant 'editing' form.
I can't seem to get the [PswdOK] value to pass from the frmLogIn object back to the VBA code in the calling event. I've tried to define the PswdOK as a Public variable and then modify it within the Private frmLogin VBA code but I guess I don't know how to do it correctly
There's probably an easier way to do this. Any other suggestions would be welcome.
I'm sure you can tell I'm new to this... MBA