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?

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

As an aside, it's good to know that switching from from view to design actually closes the form in the first view and then reopens it in the other view. I found this out the first time I used the ON CLOSE event.

[This message has been edited by jaxbuilder (edited 08-26-2000).]