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