In the recordsource query for the kids subform (make it a query if its not already), put in criteria in the query under the CoordinatorID column (or intProvider - whatever field links the 2 tables relationally):
=Forms!MyMainFormName!MyFirstSubformName!Coordinat orID (I'd recommend making the "kids" subform continuous or also having a listbox with again, criteria in the rowsource query the same as above.)
Make sure CoordinatorID is shown somewhere on the first subform (Coordinator subform). In that subform you then want to put in the OnCurrent event:
or to requery a listbox on the kids subform
Last edited by pkstormy; 08-22-08 at 22:16.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)