Two equal subdatasheets visible under a datasheet?

  • Thread starter Thread starter Ricter
  • Start date Start date
R

Ricter

Hello,
I cannot get Access to display two hierarchically equal subdatasheets
together when the form is in datasheet view. The both only are visible when
the form is in single form view.

tblCompanies
tblEmployees
tblPhoneNumbers
tblEmailAddresses

A company can have one or more employees. An employee can have one or more
phone numbers AND one or more email addresses...

Anything I'm missing, or is simply that Access cannot handle coequal
datasheets?
 
In datasheet view, a form can display only one subsheet at a time. But the
subdatasheet property can easily be set with VBA code. One possibility: add a
field to your employees form containing either the text "Show Telnums" or
"Show E-mails". Write an event procedure for a click or double-click on this
field that changes the text from one to the other and changes the
subdatasheet property appropriately.
 
Back
Top