Subdatasheets

[Guest]

I created a query (Transcript) and bind a table to that query in order to end
up with subdatasheet. In query properties window I played with the fields
which are Subdatasheet Name, Link Child Fields, Link Master Fields and it
worked. The problem is when I open a form which includes my subdatasheet,
sometimes the + icon in the subdatasheet doesnt show up. Another problem is
when I go to another form and want to go back to my main form with a command
button which opens my main form but subdatasheet doesnt work. Can anybody
help me with that problem?

 

[Larry Linson]

I see no one had answered your post in several hours. Perhaps that is,
because like me, they regard subdatasheets as "nothing but trouble", thus
don't use them, and, thus in turn, aren't able to help you on the subject.

Larry Linson
Microsoft Access MVP

 

[Guest]

By the way, thank you for your answer. I used subdatasheet and now its very
crucial for my program. Can you please help me..I have to solve that problem
otherwise my program doesnt gonna be a useful program.

 

[Stefan Hoffmann]

hi,

By the way, thank you for your answer. I used subdatasheet and now its very
crucial for my program. Can you please help me..I have to solve that problem
otherwise my program doesnt gonna be a useful program.

As Larry wrote, don't use subdatasheets nor in tables neither in queries.
They are a performance nightmare and sooner or later you need some
functionality which needs serious VBA programming. So build your
master-detail structures with forms and subforms.


mfG
--> stefan <--

 

[Stephen K. Young]

Normally, subdatasheets are created on a master form with a child subform
that is properly linked by master and child fields.

Rather than creating a subdatasheet in the query properties (which I have
never tried), use a form with a subform. Then, when you view the master form
in datasheet view, you can see the subdatasheet with the + icon.

- Steve