Limiting Records in Main Form Based on Subform

  • Thread starter Thread starter John Wessell
  • Start date Start date
J

John Wessell

Greetings!

I have a form/subform based on a one to many relationship. I only want the
main form to display records in which related records in the subform
actually exist, but I'm having trouble getting it to work.

Could someone point me in the right direction?

Many thanks,

John
 
John Wessell said:
Greetings!

I have a form/subform based on a one to many relationship. I only want the
main form to display records in which related records in the subform
actually exist, but I'm having trouble getting it to work.

Could someone point me in the right direction?
Click to expand...

You could apply a filter similar to...

[ID] IN(Select [ID] From SubTable)
 
Back
Top