Limiting Records in Main Form Based on Subform

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
 
R

Rick Brandt

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)
 
Top