If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Limiting Records in Main Form Based on Subform
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 |
#2
|
|||
|
|||
Limiting Records in Main Form Based on Subform
"John Wessell" wrote in message
... 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? You could apply a filter similar to... [ID] IN(Select [ID] From SubTable) -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to open new form based on selection in subform | Steve | Using Forms | 0 | June 24th, 2004 05:21 PM |
form doesn't update!!!!! | manish | Using Forms | 4 | June 15th, 2004 11:24 AM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |
Filter subform combobox on option button in main form | Emma | Using Forms | 1 | June 12th, 2004 12:24 AM |
Filter subform combobox on option button in main form | Emma | Using Forms | 2 | June 11th, 2004 10:29 PM |