[AccessD] Tree View Control

Boyd, Mark Thomas (US - Philadelphia) mboyd at deloitte.com
Mon Jan 23 16:53:41 CST 2006


Thanks Dan.  I'm sure that would work great, but I'm really trying to
imitate the "drill-down" and "drill-up" behavior that is similar to the
tree view control.  I want the user to click a "+" control next to the
record, and the child data appears below this record.  If the user
clicks the control again, now a "-" symbol, the child data disappears.

I appreciate the insight, as this solution would work, but the client
would like it displayed a specific way.

Thanks again.

Mark Boyd 
Senior Consultant 
Enterprise Risk Services 
Deloitte & Touche LLP 
  
Tel: +1 215 405 5576
mboyd at deloitte.com 
www.deloitte.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Monday, January 23, 2006 5:43 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Tree View Control

Mark,

Could you put your continuous form into the left side of a subform
control,
then include another form into another subform control on the right side
of
the parent form that would show the detail for the selected record on
the
left side?  Once you've selected the record in your continuous form, I
think
you can pass a recordset as the source for the form on the right.

Ok - that's just a vision I had . . . !

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Boyd, Mark
Thomas
(US - Philadelphia)
Sent: Monday, January 23, 2006 4:25 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Tree View Control

Thanks Stuart.  
I agree, I probably don't want to use the Tree View control.  I'm using
linked forms, but I'd like for the child data to display directly
underneath the parent record on the continuous form.  Placing the child
data in the form footer is a nice concept, but displays too far down on
the form.
Again, what I hope to do is make the data display a certain way.  If
there isn't a clean way of doing it, I have no problem using one of your
suggestions.

Thanks again.

Mark Boyd 
Senior Consultant 
Enterprise Risk Services 
Deloitte & Touche LLP 
  
Tel: +1 215 405 5576
mboyd at deloitte.com 
www.deloitte.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Monday, January 23, 2006 5:04 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Tree View Control

On 23 Jan 2006 at 13:59, Boyd, Mark Thomas (US - Phila wrote:

> I have the need to use a Tree View control on a form.
> Basically, I have a continuous form, with a number of records
containing
> Account #'s.  I want the user to be able to click a tree node "+"
button,
> and have detail records for this Account # displayed below. Within
this
> detail data, the user will need to update specific fields (combo boxes
and
> checkboxes).
> 
> Is the Microsoft Tree View control capable of this?  If not, are there
> other controls that have this capability?
> Any sample code would be greatly appreciated.
> 

If you need to update child records, I would not try to use a treeview,
I 
would use linked forms 

Depending on the visual requirements you can do either of the following:

1.
A continuous form (frmsubDetails) in the form_footer of your Accounts
form 
with its parent set to the key field in the main form.

2.
An unbound main form with two sub forms side by side.
A continous subform (frmsubAccounts) on the left which lists all of the 
accounts.
A hidden text box (txtAccountLink) with a control source of 
"=frmSubAccounts.Key"
A continuous subform (frmsubDetails) on the right containing the detail 
records.
Set the Parent Field of frmsubDetails to "txtAccountLink"

In either case, when you click on an Account record, the appropriate 
records will be displayed in frmsubDetails and can be edited.







-- 
Stuart


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com 


This message (including any attachments) contains confidential
information
intended for a specific individual and purpose, and is protected by law.
If
you are not the intended recipient, you should delete this message. 


Any disclosure, copying, or distribution of this message, or the taking
of
any action based on it, is strictly prohibited. [v.E.1]
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list