Subdatasheet Inquiry

  • Thread starter Thread starter Emmz
  • Start date Start date
E

Emmz

I have several main tables that have 3 fields that I have going to their
appointed look-up table(Module, Individual, WBS Section). Is there a way to
show all of the subdatasheets for each table instead of just one?

Maybe I'm confused.

Emma
 
Yes

Use a form with multi-layered forms.

Not sure about subdata sheets as these would (obviously) require tables to
be used for more than storeing data - which is all there meant for
 
First, you should be viewing your data in forms, not tables. If you like the
spreadheet-like viewing of a table, you can get the same effect by specifying
datasheet view for your form. There are several advantages to datasheet view
over continuous forms view - for example, the user can change font size and
column widths.

In datasheet view, a form can display only one subdatasheet at a time, but
the sheet displayed can be changed via a property of the parent form. Here's
one approach I've used in the past:

On the parent form, I added a drop-down listbox control whose row source is
a hard-coded list of subforms. When the user selects one from the list, the
associated event procedure changes the subdatasheet property of the parent to
the chosen one.
 
Back
Top