suppressing Master Records for which No Child record is found

I

I H Naqvi

I have One Master Form named on which there are 3 embaded Sub Forms developed
from 3 different querys. these forms are liked from Master by MS
Access automatically when i draged them on Master Form. Now I want that
Master Form Should Show records for which All 3 Queries or Sub Forms has
Atleast one
Child Record. Pl Help me as I m new in MS Access. Also tell me how to count
Child records on Opening of Master Form as well as when Switching between
Master records
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
Quering only those Parent Rec where Child rec exist 4
Linking Child Timelines to Multiple Parents 0
Access Subforms - Master/Child fields - one-to-many relationship 1
refresh an open form using records from another open form? 27
keep subform synchronized with main form in Microsoft Access 2003 1
Subform autoloading 0
Need loop help, add records by field that match query records 3

Top