Combobox Applying Filter

Hi,

I have a combobox in a form which should filter records by user names. But it only filters it once (the first time) and then if you try to filter it again, it doens't do anything. I put the Macro I made in the "OnChange" property, but it doesn't seem to work. I don't have a control source because the user names are on a different table (if I put in the control source in, it won't let me select anything from the combobox).

Can you guys please help me? Thanks!

I figured it out... I put a Requery in front of my ApplyFilter action in the Macro, so each time it does it twice and then applies the filter.