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.

Thanks,

Glen

In the After Update event of the combo box put:

Me.YourSubformCONTAINERNameHere.Form.Requery

The container is the control that houses the subform on the main form. The name CAN be different than the subform name so make sure to pick the correct name. If it is the same as the subform then no problem, but if it is different, use the container name.