Bob -- your modified version includes some very intriguing processes. I wish we had had this dialogue several months ago when working on the general architecture. I will further review whether or not I can simply plug in your form into the actual database. That is, we have some business rules which may preclude it. For example, in some cases, the users do want to see which members have not bee assigned to a billet (vs. removing their names from the combo).
However, at the same time, I am very much intrigued by the ability to remove a value (e.g., lastname) from the combo once that value has been assigned. I looked at the VBA but I didn't recognize which code or property automatically remove a previously assigned lastname from the values left/shown in the combo.
Could you please elaborate what function/code is performing that auto-refresh?
Thanks,
Tom