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)
 

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

Populate main form from subform record 0
DLookup in Continuous form 0
filtering a form based on the values of a subform 0
First Subform record gets modified when closing form 3
Subform 7
Filter on Subform Not Displaying as Expected 1
Subform only showing 1 record instead of all records 6
Trouble associating parent form record to subform's record 1

Top