Good afternoon.
I've created a Login form for my Access 2010 db which prompts end users for USERID and PASSWORD upon opening the db. When the Login is successful, the Navigation Form is prompted, and I have 7 sub forms within this Navigation form.
Depending on the type of end user, I'd like to restrict the view of these 7 sub forms. For 'Admins', no restrictions need to be made, all 7 sub forms should be visible. For 'Guest' users, I want to restrict the visibility to 5 sub forms (the other 2 are for data enty on the Admin side)
I've seen several threads and solutions for code and listboxes, but none for using a 2010 wizard-created Navigation Form w/ Sub forms.
Any insight on how to go about this?