Popping open a sub-list



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?

Access Developer

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

D Sum on a sub form 1
ComboBox with Sub lists 3
sub-forms and list choice 2
Perplexing Pop Up Problems 5
Dropdown list sub group 2
Combo Box, List Box & a Sub Form 4
pop 3 2
Open main and sub form blank 1