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.

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

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)

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

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)