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!!!

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" <(E-Mail Removed)> wrote in message
news:5C63F170-0A75-4F2B-8F31-(E-Mail Removed)...
> 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!!!

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" <(E-Mail Removed)> wrote in message
> news:5C63F170-0A75-4F2B-8F31-(E-Mail Removed)...
> > 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!!!
>
>
> .
>

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" <(E-Mail Removed)> wrote in message
news:F438B0BA-4974-4794-80D0-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:5C63F170-0A75-4F2B-8F31-(E-Mail Removed)...
>> > 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!!!
>>
>>
>> .
>>

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" <(E-Mail Removed)> wrote in message
> news:F438B0BA-4974-4794-80D0-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:5C63F170-0A75-4F2B-8F31-(E-Mail Removed)...
> >> > 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!!!
> >>
> >>
> >> .
> >>
>
>
> .
>

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]
> .
>