Link to home
Start Free TrialLog in
Avatar of Mel
MelFlag for United States of America

asked on

Access 2003 - Combo box does not filter form after using toolbar (or right-click) remove filter.

Have a continuous form that has a combo box to filter for records by name.  It works until you use remove filter using the toolbar or right click method.  
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Please post the code for the combo box (combobox afterupdate event procedure I would expect)
Avatar of Mel

ASKER

Here it is:

Private Sub Analyst1_AfterUpdate()
Me.Requery
End Sub
ASKER CERTIFIED SOLUTION
Avatar of lee555J5
lee555J5
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mel

ASKER

That worked!  I originally put the filter in the query field which works great except if used in combination with the toolbar filter.  So thanks for the solution that does work.
Avatar of Mel

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for mlaurin's comment http:/Q_27424025.html#37058889
Assisted answer: 500 points for lee555J5's comment http:/Q_27424025.html#37058623

for the following reason:

Thanks!!
Avatar of Mel

ASKER

Made a mistake with accepting.  Not sure how it happened that my comment shows as accepted.  It should only be ee555J5's.  
Will try to figure out how to change this!
Avatar of Mel

ASKER

Made a mistake with accepting.  Not sure how it happened that my comment shows as accepted.  It should only be ee555J5's.