Hi All,
I want to update a column in my Users table through a subform.
I have made a mainform where you can choose a Department (from
Department table), then a subform pops-up showing the users in that
Department.
Now I want to make 2 buttons on this subform to pop-up new (sub)forms
to add or delete a user to/from this Department, but this DepartmentID
must be updated in the User table, how can I fix this and how do I
refresh the first subform after adding/deleting a user to/from this
Department.
Thx in advance for your help.