I have a form that contains a subform that displays a many to many relationship. The form is a change document that is related to people. So for instance, when a change affects three people, these three people should be reprsented in the subform.
I have this working fine. There is a dropdown box that lists all available people (stored in another table) and they can be added to the subform. The problem lies when a whole bunch of people need to be added to the subform. Say there is a change that effects all people in a certain department, it would nice if you could run a query for all people in that department and then just add them (as opposed to adding each one individually). I have no clue how to do this. I was able to read in all the saved query names but I can't get to the underlying sql.
Does anyone have any ideas on how I could implement this?
I have this working fine. There is a dropdown box that lists all available people (stored in another table) and they can be added to the subform. The problem lies when a whole bunch of people need to be added to the subform. Say there is a change that effects all people in a certain department, it would nice if you could run a query for all people in that department and then just add them (as opposed to adding each one individually). I have no clue how to do this. I was able to read in all the saved query names but I can't get to the underlying sql.
Does anyone have any ideas on how I could implement this?
