HELP! Subdatasheet Problem!

[John Lane]

Is is correct that subdatasheets don't work when the tables are attached?
When I open the backend mdb that has the tables, it works (works = the little
plus/minus sign is visible). When going via the "front-end" mdb to which the
tables are attached, no plus/minus sign. Is there something I need to do in
the front-end mdb? Thanks.

 

[John Vinson]

Is is correct that subdatasheets don't work when the tables are attached?

No, it isn't. My linked tables show subdatasheets, at least until I
set them all to [None], which I do routinely.

When I open the backend mdb that has the tables, it works (works = the little
plus/minus sign is visible). When going via the "front-end" mdb to which the
tables are attached, no plus/minus sign. Is there something I need to do in
the front-end mdb? Thanks.

I find subdatasheets (and table datasheets in general) to be of very
limited utility. Why not use Forms with Subforms? They're certainly
not constrained by using linked tables!

John W. Vinson[MVP]

 

[John Lane]

OK, so how do I make them work? Is there some property I have to set in the
front end to enable it? In the front end, they all have [Auto] with no
Master/Child link set. I also went into table view, brought in all the tables
and it set the join properties automatically based on what I did in the back
end. What else do I have to do? Thanks.

Is is correct that subdatasheets don't work when the tables are attached?

No, it isn't. My linked tables show subdatasheets, at least until I
set them all to [None], which I do routinely.

When I open the backend mdb that has the tables, it works (works = the little
plus/minus sign is visible). When going via the "front-end" mdb to which the
tables are attached, no plus/minus sign. Is there something I need to do in
the front-end mdb? Thanks.

I find subdatasheets (and table datasheets in general) to be of very
limited utility. Why not use Forms with Subforms? They're certainly
not constrained by using linked tables!

John W. Vinson[MVP]