I don't think I've run into this before. I have a form that has a combobox. The combobox row source is a select query that gets its records from a table. The table has a new yes/no field named "Inactive". If a record has the yes/no field marked "True" then the record does not show up in the combo-box. This is the way it should work for new records on the form.
But the problem is, for any existing records, when the form displays a record, the combo-box displays nothing. I would like it to display the value if it is not a new record even if the combobox record is marked "True".
Ho do I get around this issue?