can u do this

[Neo]

I have a form that is filtered, i then have a search which allows the user to select a record form a combo box,

at present all the records are shown in the combo box . Can i just show the records remaining after the filter in the combo box

 

[The_Doc_Man]

If the form will ALWAYS be filtered, perhaps the easiest way to do this as you describe it is to base the form on a query that always applies the filtration criteria rather than on the raw table with a filter added.

The alternative is for your code, at Form_Load event, to see if the form's properties include an enabled filter. You would have to change the .ControlSource property of your combo box to match the criteria of the enabled filter.