HELP! Subdatasheet Problem!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Is is correct that subdatasheets don't work when the tables are attached?
Click to expand...

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.
Click to expand...

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]
 
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.

John Vinson said:
Is is correct that subdatasheets don't work when the tables are attached?
Click to expand...

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.
Click to expand...

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]
Click to expand...
 
Back
Top