Tricky problem with combo box contents

M

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?
 
J

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top