Filter changine fields??

[branston]

Filter changing fields??

Hi,

I have something odd going on in one of my forms!
Its running from a query, and it a continuous form.
There is a combo box in the form header with an After Update code to filter the records for whatever is selected.

However...
The selection in the combo box seems to be changing the filter field for the first records (e.g. If I'm filtering for November, and then change the filter to January the first November record has its month cahnged to January.)

I'm just using the following simple code:
DoCmd.ApplyFilter , "[MonthName] = '" & Me.ComboMonth & "'"

Any ideas where/why it might be going wrong?

 

[JANR]

Your combobox is BOUNED to your datasource, make it UNBOUND by removing it's ControlSource.

JR

 

[branston]

oh, ace!
Thank you so much - I do love it when it's something that simple!