I want to make a combo box that uses criteria to limit the drop down records. But I don't want them to limit the display/stored records.
To give you more of the scenario details: I want the combo box to drop down all current staff, but I don't want staff that have been selected to be removed from the record/field once they have left.
At the moment, when I simply apply the criteria to the combo box row source ("Is Null" - to my DateDeparted field), this is what happens. The criteria apply to the values stored in the control (and possibly the underlying table, I haven't checked) and not just the values displayed in the drop down box.
Does anyone have any brilliant ideas? I can't see a way round it but I'm hoping that's my inexperience showing.
To give you more of the scenario details: I want the combo box to drop down all current staff, but I don't want staff that have been selected to be removed from the record/field once they have left.
At the moment, when I simply apply the criteria to the combo box row source ("Is Null" - to my DateDeparted field), this is what happens. The criteria apply to the values stored in the control (and possibly the underlying table, I haven't checked) and not just the values displayed in the drop down box.
Does anyone have any brilliant ideas? I can't see a way round it but I'm hoping that's my inexperience showing.
