Mel
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.
Please post the code for the combo box (combobox afterupdate event procedure I would expect)
ASKER
Here it is:
Private Sub Analyst1_AfterUpdate()
Me.Requery
End Sub
Private Sub Analyst1_AfterUpdate()
Me.Requery
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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!!
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!!
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!
Will try to figure out how to change this!
ASKER
Made a mistake with accepting. Not sure how it happened that my comment shows as accepted. It should only be ee555J5's.