Advance or Not Advance..that is the question.

I have a form consisting of more than one table and it is set up to resemble
index cards so that you can click on a tab to move between the categories of
data to enter. The initial tab is used to find the record you want and then
you click on the appropriate tab to go to that data to enter. The problem is
that when I select the main record in the first tab, if I go over to another
tab the arrows to advance records are still visible at the bottom of the form
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6732-advance-or-not-advance-that-question.html
and you can advance to another record from any of the tabs. Is there a way
so that the only way to advance to another record and its data is from the
first tab(index card) view? Can I pick the record that I need and when I go
to another tab(index card) the arrows disappear or are disabled?

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6732
Thanks,
RM

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Have each tab consist of its own subform.

"WCDoan" wrote in message
news:140C16CE-E1BF-4066-8C12-C010C5F149E0@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6732
>I have a form consisting of more than one table and it is set up to
>resemble
> index cards so that you can click on a tab to move between the categories
> of
> data to enter. The initial tab is used to find the record you want and
> then
> you click on the appropriate tab to go to that data to enter. The problem
> is
> that when I select the main record in the first tab, if I go over to
> another
> tab the arrows to advance records are still visible at the bottom of the
> form
> and you can advance to another record from any of the tabs. Is there a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6732
> way
> so that the only way to advance to another record and its data is from the
> first tab(index card) view? Can I pick the record that I need and when I
> go
> to another tab(index card) the arrows disappear or are disabled?
>
> Thanks,
> RM

Not enough info for us to know your set-up ...

A Form is bound to only one RecordSource which can combine multiple Tables
in some way related. However, your description indicates otherwise.

Describe in details of the relevant Tables, the RecordSource of the Form,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6732
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6732
how your TabControl is set up (Subforms in TabPages?) ...

--
HTH
Van T. Dinh
MVP (Access)



"WCDoan" wrote in message
news:140C16CE-E1BF-4066-8C12-C010C5F149E0@microsoft.com...
>I have a form consisting of more than one table and it is set up to
>resemble
> index cards so that you can click on a tab to move between the categories
> of
> data to enter. The initial tab is used to find the record you want and
> then
> you click on the appropriate tab to go to that data to enter. The problem
> is
> that when I select the main record in the first tab, if I go over to
> another
> tab the arrows to advance records are still visible at the bottom of the
> form
> and you can advance to another record from any of the tabs. Is there a
> way
> so that the only way to advance to another record and its data is from the
> first tab(index card) view? Can I pick the record that I need and when I
> go
> to another tab(index card) the arrows disappear or are disabled?
>
> Thanks,
> RM