Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Forms Coding > Looking for Cod...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 41515 of 43412
Post > Topic >>

Looking for Code to Expand Subform Rows Automatically

by =?Utf-8?B?a2Vuaw==?= <kenk@[EMAIL PROTECTED] > Aug 6, 2008 at 05:49 AM

I've created a form that contains five levels of subforms - each a subform
of 
the parent above it.  Each subform is displayed as a datasheet.
Form
  Subform1
    Subform2
      Subform3
        Subform4

Normally, the user selects a key from a combo box on Form that filters the

recordset of Form to a particular record.  Access populates the Subforms 
based on parent/child relation****ps between the tables used as data
sources 
for the Subforms.  I then leave it up to the user to navigate through the 
subform rows by manually expanding and/or contracting the various row 
indicators. 

Now I've found a case where I would like to have Access automatically
expand 
the necessary subform rows to display a particular row on Subform3.  The
user 
will supply the key data to identify the row to be pointed to on Subform3
by 
using another combo box on Form.  A query will provide the key data
necessary 
to identify the applicable Form record and Subform1 and 2 rows.

So, with all the key data available, I’m looking for the code to cause 
Access to expand the necessary rows and focus on the Subform3 row
selected.
 




 2 Posts in Topic:
Looking for Code to Expand Subform Rows Automatically
=?Utf-8?B?a2Vuaw==?= <  2008-08-06 05:49:02 
RE: Looking for Code to Expand Subform Rows Automatically
=?Utf-8?B?SlN0cmluZw==?=   2008-08-06 09:37:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 19:57:36 CST 2008.