combo box on Continuous Forms 1

[pdmon]

is there anyway I can apply a filter to the control source of a combo box on a continuous form that wont remove what is displayed in previous records when they dont match the current records filter? it is a bound form and I would like to keep it that way. any help would be appreciated thanks

 

[MajP]

Here is how I would do it. Buid a combobox and a textbox with the same control source. Shrink the combobox down so that it is only a downward arrow. Put right next to the textbox. This will look and work like a combobox, but the display is coming from the textbox. The only problem will be that the list will be offset to the right. A solution is to put the arrow on the left of the textbox. Now you can change the recordsource of the combobox on the on current event without altering any displayed information
There may be a better way, but this does work.

 

[Zion7]

As MajP said.
Or, Just thinking out loud,
Create modular level variable
Assign it's value on every AfterUpdate event, of Combo.
On Current event of Form, assign variable value to Combo.

may have to set Combo to "InList = No

 

[MajP]

If you go with my idea here is a couple of things to consider. To force the user to select from the list you can simply lock the text box. You can also build your own pseudo "not in list" event. You can do this in the text box's before update event. Compare the text to that in the list.