 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008Two equal subdatasheets visible under a datasheet?
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.  SignatureTedMi Thanks Tedmi, Which subdatasheet property are you referring to please? > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.