Prev: Stephen Leban's Conditional Formatting
Next: error 0
From: SummitSeeker on 21 May 2010 10:49
Hello...

I have a form where i have multiple subforms. The main subform is our
client's contact information, and the subform I am trying to add a button for
is for our call notes to log our call. The call log subform is linked to the
customer contact info via customer number and displays the correct call notes
for each client as i go through our client.

I am having trouble adding a button to navigate through the different call
log records. Each time i push teh button it goes through our customer's
contact information.

How can i add the button so it will go to the "next" or "previous" records
of our call logs and not the clients?

Thanks so much nor any help.
From: SummitSeeker on 21 May 2010 10:54
Sorry I forgot to mention that I would like the button on the main form and
not on the subform...

Thanks again,
-SS-

"SummitSeeker" wrote:

> Hello...
>
> I have a form where i have multiple subforms. The main subform is our
> client's contact information, and the subform I am trying to add a button for
> is for our call notes to log our call. The call log subform is linked to the
> customer contact info via customer number and displays the correct call notes
> for each client as i go through our client.
>
> I am having trouble adding a button to navigate through the different call
> log records. Each time i push teh button it goes through our customer's
> contact information.
>
> How can i add the button so it will go to the "next" or "previous" records
> of our call logs and not the clients?
>
> Thanks so much nor any help.
From: Daryl S on 21 May 2010 11:37
SummitSeeker -

You should put the button on the subform and test it out. Once it works,
you can make the button invisible. In the code for the button, change the
Private to Public in the function header. This will allow the main form to
call it. Then use the button on the main form to call the subform's button.
It will look something like this (use your form and control names):

Call Me.SubformName.Form.SubformButtonNmae_Click

--
Daryl S


"SummitSeeker" wrote:

> Sorry I forgot to mention that I would like the button on the main form and
> not on the subform...
>
> Thanks again,
> -SS-
>
> "SummitSeeker" wrote:
>
> > Hello...
> >
> > I have a form where i have multiple subforms. The main subform is our
> > client's contact information, and the subform I am trying to add a button for
> > is for our call notes to log our call. The call log subform is linked to the
> > customer contact info via customer number and displays the correct call notes
> > for each client as i go through our client.
> >
> > I am having trouble adding a button to navigate through the different call
> > log records. Each time i push teh button it goes through our customer's
> > contact information.
> >
> > How can i add the button so it will go to the "next" or "previous" records
> > of our call logs and not the clients?
> >
> > Thanks so much nor any help.
From: SummitSeeker on 21 May 2010 17:44
Ahh..haa.. That is exactly what i needed... Awesome and thank you for the
help.

-SS-

"Daryl S" wrote:

> SummitSeeker -
>
> You should put the button on the subform and test it out. Once it works,
> you can make the button invisible. In the code for the button, change the
> Private to Public in the function header. This will allow the main form to
> call it. Then use the button on the main form to call the subform's button.
> It will look something like this (use your form and control names):
>
> Call Me.SubformName.Form.SubformButtonNmae_Click
>
> --
> Daryl S
>
>
> "SummitSeeker" wrote:
>
> > Sorry I forgot to mention that I would like the button on the main form and
> > not on the subform...
> >
> > Thanks again,
> > -SS-
> >
> > "SummitSeeker" wrote:
> >
> > > Hello...
> > >
> > > I have a form where i have multiple subforms. The main subform is our
> > > client's contact information, and the subform I am trying to add a button for
> > > is for our call notes to log our call. The call log subform is linked to the
> > > customer contact info via customer number and displays the correct call notes
> > > for each client as i go through our client.
> > >
> > > I am having trouble adding a button to navigate through the different call
> > > log records. Each time i push teh button it goes through our customer's
> > > contact information.
> > >
> > > How can i add the button so it will go to the "next" or "previous" records
> > > of our call logs and not the clients?
> > >
> > > Thanks so much nor any help.
 | 
Pages: 1
Prev: Stephen Leban's Conditional Formatting
Next: error 0