Popping open a sub-list

  • Thread starter Thread starter Puppet_Sock
  • Start date Start date
P

Puppet_Sock

So I have a table with associated one-to-many relationships with other
tables. Such as, a document can have many authors.

And I want to show a list of the documents, with some kind of control
like a + sign or something. And selecting one document in the list
then clicking on the + sign pops opens the list of authors under the
document, and changes the + to a - (or something). Then clicking the -
closes the sub-list and changes it back to a +.

I'm guessing I could brute-force that with quite a bit of VBA code. Is
there a simpler way?
 
Unless it has been changed in recent Access versions, you can't use a
Subform Control in a continuous-forms view. And, if I understood the
question, that is what puppet-sock wanted to do. You can do it with
slightly more complexity... a continuous-forms view so you can click and
open a single-form-view form of that record, which can contain a subform.
 
Back
Top