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
|
|||
|
|||
If No Records in Subform, Parent Form Record doesn't display
If I don't have any records in a subform, the record in the parent form
doesn't display on my main form. The record is in the underlying table for the parent form, so I don't understand what the problem is. I'm sure the solution is simple and I'll kick myself later. Thanks for the help! -- Thanks. |
#2
|
|||
|
|||
If No Records in Subform, Parent Form Record doesn't display
"Melissa" wrote in message
... If I don't have any records in a subform, the record in the parent form doesn't display on my main form. The record is in the underlying table for the parent form, so I don't understand what the problem is. I'm sure the solution is simple and I'll kick myself later. My guess is that the main form is based on a query that inner-joins the "parent" table to the table on which the subform is based. In a main-form/subform arrangement, this is neither necessary nor desirable, since it excludes any parent record that doesn't have a match. Remove the child table from the main form's recordsource query. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
#3
|
|||
|
|||
If No Records in Subform, Parent Form Record doesn't display
The underlying query (record source) for the form does not include the child
table in it. Additionally, the record in question shows up in the underlying query (record source). So this that isn't the problem. Is there somewhere to establish the relationship between the parent and child? I want to show all records from the underlying query (record source). Help! -- Thanks "Dirk Goldgar" wrote: "Melissa" wrote in message ... If I don't have any records in a subform, the record in the parent form doesn't display on my main form. The record is in the underlying table for the parent form, so I don't understand what the problem is. I'm sure the solution is simple and I'll kick myself later. My guess is that the main form is based on a query that inner-joins the "parent" table to the table on which the subform is based. In a main-form/subform arrangement, this is neither necessary nor desirable, since it excludes any parent record that doesn't have a match. Remove the child table from the main form's recordsource query. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
#4
|
|||
|
|||
If No Records in Subform, Parent Form Record doesn't display
"Melissa" wrote in message
... The underlying query (record source) for the form does not include the child table in it. Additionally, the record in question shows up in the underlying query (record source). So this that isn't the problem. Is there somewhere to establish the relationship between the parent and child? I want to show all records from the underlying query (record source). Help! What is the recordsource of the main form? If it's a query (stored or in-line SQL), what is the SQL of the query? Are you saying that if you open that query as a datasheet, you can see the record in question, but it doesn't appear on the form? Maybe the form has a Filter property that would exclude the record, and Filter On Load is set to yes. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
#5
|
|||
|
|||
If No Records in Subform, Parent Form Record doesn't display
Bingo! There is a filter on it that I'll need to fix. The filter looks at
the PK in an SQL statement that includes the child table. Thanks for you help!! -- Thanks. "Dirk Goldgar" wrote: "Melissa" wrote in message ... The underlying query (record source) for the form does not include the child table in it. Additionally, the record in question shows up in the underlying query (record source). So this that isn't the problem. Is there somewhere to establish the relationship between the parent and child? I want to show all records from the underlying query (record source). Help! What is the recordsource of the main form? If it's a query (stored or in-line SQL), what is the SQL of the query? Are you saying that if you open that query as a datasheet, you can see the record in question, but it doesn't appear on the form? Maybe the form has a Filter property that would exclude the record, and Filter On Load is set to yes. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|