Form and sub-form for multiple tables

[mbritt60]

I have an Access 2013 database created with different tables for Users, Applications, Departments, and Supervisors. I also have a table created that will contain all this information plus an additional field of Removal Date (tblApplicationAccess).



I want a form that will update the table created with all the information (tblApplicationAccess) and then display a sub-form that displays any and all Applications a particular user has access to.

[mbritt60]

Update to my issue.
I have changed each of the fields in the main form to be combo box fields back to the individual tables. So for the Application field, it has a Control Source of the multiple field table (tblApplicationAccess) and a Row Source of the tblApplications. The Department Field has a Control Source of tblApplicationsAccess-Department and a Row Souruce of the tblDepartment table. The User Name and Supervisor fields follow this same example.

I have a separate table that contains all the records that have been previously added and I added that table to this form as a sub-form.

How do I make sure that when I select a User, the Sub-Form displays all records currently associated with that user?

[ranman256]

you will need a table to hold the apps permissions
tUserApps=
userID, app

make it a subform to the User master.
Enter the apps that 1 user can have.
Then if the user tries open a form, and it exists in tUserApps, then open it.

[mbritt60]

Thanks, and I think I understand.
So my main form is linked to the table that i want updated with all the data. The subform would then be the table with just the username and applications they have?

Maybe I'm trying to do too much with one form.

I want to have a form that displays all the associated applications a user has access to.
I want a form that will update a master table with the users name, their department, the name of an application, their supervisor, and the date they were removed from the application.