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

ComboBox with Sub lists 3
open form/sub-form 2
Project/Sub-Project In Continuous List? 2
pop up form to open one record with dlookup 1
Sub-categories 1
Sub Reports 7
Sub Reports 6
Sub Forms 3