Tricky problem with combo box contents

[mscertified]

I have a combo box that lists people, it's bound to an id but displays the
name.
In the table, each person has an Active switch (boolean) which can be yes or
no.
Right now, on a new record, only active people are diplayed and on an
existing record all people are shown. I switch the combo box source
dynamically.
Inactive people are retained for referential integrity purposes.

The user wants a further refinement, on an exisitng record they only want
the drop-down to display active people PLUS the existing person (who may be
inactive).
Anyone been there and done that and know a neat way?

 

[Jeff L]

You said you change the row source based on new or existing records.
If you only want active plus the existing, your row source query should
be
"Select ID, FullName

From YourTable

Where Active = Yes
Or ID = " & Me.YourComboBoxName & ";"

Hope that helps!