I have a form with a datasheet style subform which has a combo box with over 100 values on it. It's too long to really be useful, and many of the values are old so they're not really needed for new records.
I'd like to filter it using a y/n flag so that only the "active" values appear on the pick list. I added the flag to the table and updated the query behind the combo box to only display the values from the table where the flag is set to true. That way only the active values can be used when adding a new record, but the inactive values are still on the table, so the records that used them aren't orphaned.
The problem is that now when I look at the datasheet subform, I only see a value in that field when it is an "active" value. All of the other values from the table are blanked out in that field.
Does anyone know of a way to filter the combo box to only display the active values when creating a new record, but still display all possible values in that field for existing records? Please share! Thanks.
I'd like to filter it using a y/n flag so that only the "active" values appear on the pick list. I added the flag to the table and updated the query behind the combo box to only display the values from the table where the flag is set to true. That way only the active values can be used when adding a new record, but the inactive values are still on the table, so the records that used them aren't orphaned.
The problem is that now when I look at the datasheet subform, I only see a value in that field when it is an "active" value. All of the other values from the table are blanked out in that field.
Does anyone know of a way to filter the combo box to only display the active values when creating a new record, but still display all possible values in that field for existing records? Please share! Thanks.
