I have a survey database that contains a combo box drop-down for the surveyors to select their name from to specify who is conducting the survey. This person serves as the "primary" surveyor. There is button that takes them to another form to select any additional surveyors (e.g., observer, qaqc, etc.) from another combo box of names. I think the answer is probably something simple, but how to I dynamically reduce the combo box on the second form based on the value selected for the primary surveyor on the main form? That is, I don't want the primary surveyor's name to show up, cause they cannot also be an observer at the same site.
Thanks in advance,
David