Drill Down Method

[lilbit27]

Does anyone know the based way to use the "Drill Down" method, without
having to using a lot of subforms that you make visible or invisible.

I would like to use one form and functions that say if this is click
then show next level of data by either running the query or changing
the recordsource to another query.

 

[Larry Linson]

Yep, I did something like that to traverse a self-referencing table... a
form for the parent, and a subform for the children. Double-clicking a child
"promoted" it to parent, and displayed its "children".

Main form, single form view. Subform, continuous forms view. Double-click a
record on the subform, the code takes that unique id, creates a new SQL
Statement for the main Form, and replaces it. Oh, yes, I also stored the SQL
statements in an array, to allow retracing your steps... like a "back
button".

Larry Linson
Microsoft Access MVP

 

[lilbit27]

So how many forms did you have.