subform embedded in a tab control within an unbound form wont update

[indyccmc]

I have a switchboard that is unbound. It has two combo boxes for date range selection, command buttons that lead to reports and key entries, and a tab control that displays subforms for special dept.'s that use the dates selected as controls in their underlying queries.

My problem: I can not get the embedded subforms within the tab control to update. They update when the form is taken into and back out of design view, but other than that, not a single kind of manipulation I have tried will work.

Can anyone help me solve this?

 

[accesswatch]

You need to REQUERY the subform to pick up the records containing your selection criteria.

Look up REQUERY Method in the help file for examples of how to do this
Hope this helps
Trevor from Accesswatch.co.uk