Combo Box refresh

[ScottF]

I have a Combo Box on a form that is fill with Rep Number. I also have to text box for Begining Date and Ending Date on the form. After entering the begining and ending date you click on the combo box to enter the Rep number then the combo box run a marcro. The macro open a Query that use the dates and the Rep number and fill a subform with the query information. The subform is a database form. It all work great escape the Subform just add the additional data instead of refresh it with the new Query information. Why?

 

[Jack Cowley]

You don't need to run the query. If the subform is based on the query with the parameter dates and RepID coming from the form then just requery the subform in the After Update event of the combo box.

hth,
Jack