How can i Apply a filter to a combo box

Hi Everyone.

I have a combo box which navigates to a selected record. Works fine.

What I would like to do is when I apply a filter to the main form the combo box is on, I would like to apply the same filter to the list of records displayed by the combo box.

I have tried many different approaches, but its beyond me so I thought Id better ask the experts.

Here is the usual after update code for the combo box:

Please Login or Register  to view this content.

Any help will be very much appreciated.

I think all that you need to do is tell the combo to ReQuery. This assumes that the combo's source is based on the filtered form data.

This would be in the code section that performs the filtering of the form.

' Clear the combo
Me.Combo = Null

' If the combo RowSource (SQL) needs to change, do it here
strSQL = ????
Me.Combo.RowSource = strSQL

' Force a re-query
Me.Combo.Requery

I think all that you need to do is tell the combo to ReQuery. This assumes that the combo's source is based on the filtered form data.

This would be in the code section that performs the filtering of the form.

'

Please Login or Register  to view this content.