I have a subform in my form that is filtered by a combo box. Once the user selects a Route name from the combo list I want the subform to display the route information. The problem I am having is that the subforn does not display anything until I proceed to the next record and then go back to the first record entered. How can I get the subform to refresh and populate with the filtered information as soon as the user selects the route name from the combo box? I thought I could just requery the subform in the after update of the combo box but I am doing something wrong.
Any help is appreciated.