Hi,
I want to validate below two conditions below when the user is trying to log in. Please find attached the VBA table and the Form.
(i) users not part of the department
(ii) users not available in the system
Access DB.png
User Form.png
Only users which are from the correct department must be able to log in. The Department dropdown value contains 5 departments as shown in the Access DB image.
Please let me know if any additional information is required. Please help me with the code.
Thanks
Bookmarks