coding between subforms
in [Forms]
|
Prev: read focus of controls
Next: Database crashing
From: Krykota on 3 Jun 2010 16:02 My apologies Jeff. I will be more attentitive in the future. Thanks for your response. "Jeff Boyce" wrote: > The expression you posted does not use the same syntax as the expression I > offered. > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > > "Krykota" <Krykota(a)discussions.microsoft.com> wrote in message > news:F438B0BA-4974-4794-80D0-A250C6D20393(a)microsoft.com... > > Jeff, thanks for the reply. > > > > I verified that the path is complete and I still get the message that > > Access > > cannot find what I ask of it. > > > > Here is what I have as an OnClick event: > > > > Forms!RepairLab!Form!CustomerDetail!CustomerID = > > Forms!RepairLab!Form!CustomerList![CustomerID] > > > > The idea is that by clicking on the name of the customer, the accompanying > > subform CustomerDetail will filter to display the information on the > > customer > > selected in the CustomerList subform. There are two subforms on one tab > > control page form. > > > > Would putting a hidden CustomerID control on the main form help link the > > two > > subforms to allow for the filtering? If so, how would I direct focus from > > the list to the detail? > > > > "Jeff Boyce" wrote: > > > >> When referring to an embedded subform, you need to call out the complete > >> path. Something like (untested): > >> > >> Forms!YourMainForm!YourSubformControlName.Form!YourControlOnSubform > >> > >> > >> Regards > >> > >> Jeff Boyce > >> Microsoft Access MVP > >> > >> -- > >> Disclaimer: This author may have received products and services mentioned > >> in this post. Mention and/or description of a product or service herein > >> does not constitute endorsement thereof. > >> > >> Any code or pseudocode included in this post is offered "as is", with no > >> guarantee as to suitability. > >> > >> You can thank the FTC of the USA for making this disclaimer > >> possible/necessary. > >> > >> "Krykota" <Krykota(a)discussions.microsoft.com> wrote in message > >> news:5C63F170-0A75-4F2B-8F31-955784861551(a)microsoft.com... > >> > In Access 2007, I have a main form housing a tab control. On one page > >> > of > >> > my > >> > tab control, I have two subforms. The first subform lists my customers > >> > getting the data from a query in which I merge the first and last names > >> > and > >> > have a customer id (two fields). This form presents data in a > >> > continuous > >> > form list. The second subform has the detailed information on the > >> > customer. > >> > > >> > My goal and intent is to be able to click either on a button (linked to > >> > the > >> > customer id), the name of the customer, or even utilize toggle buttons > >> > (in > >> > which the caption is the customer name - preferred as a method to > >> > highlight > >> > the selected customer) and the detailed data on the customer is > >> > displayed > >> > in > >> > the second subform. > >> > > >> > I have tried doing an OnClick macro on the name, however, I am unable > >> > to > >> > direct my attention into the correct form (says it cannot find the > >> > form) > >> > even > >> > when I use the wizard to create the macro. > >> > > >> > Any help is greatly appreciated. > >> > > >> > Thanks in advance!!! > >> > >> > >> . > >> > > > . >
From: Krykota on 3 Jun 2010 16:03
Marshall, thank you for your help. SPOT ON!!!!!! Quick, easy, and highly functional. THANK YOU!!!! "Marshall Barton" wrote: > Krykota wrote: > > >In Access 2007, I have a main form housing a tab control. On one page of my > >tab control, I have two subforms. The first subform lists my customers > >getting the data from a query in which I merge the first and last names and > >have a customer id (two fields). This form presents data in a continuous > >form list. The second subform has the detailed information on the customer. > > > >My goal and intent is to be able to click either on a button (linked to the > >customer id), the name of the customer, or even utilize toggle buttons (in > >which the caption is the customer name - preferred as a method to highlight > >the selected customer) and the detailed data on the customer is displayed in > >the second subform. > > > >I have tried doing an OnClick macro on the name, however, I am unable to > >direct my attention into the correct form (says it cannot find the form) even > >when I use the wizard to create the macro. > > > > I don't do macros, but if you can live with a little VBA > code or can translate VBA to a macro, you can synchronize > two subforms automatically without a button or any other > user action. > > Add a hidden text box (named txtLink) to the main form. > Then add a line of VBA code to the continuous subform's > Current event procedure: > Parent.txtLink = Me.theprimarykeyfield > > With that in place, the single view subform control can set > the Link Master property to txtLink and the Link Child > property to theprimarykeyfield. > > This way the single view subform will always display the > details for whatever record you make current in the > continuous subform, regardless of how you navigate to it. > > -- > Marsh > MVP [MS Access] > . > |