HELP PLEASE!!!

I need to know how to link a subform to another subform inside a tab
control. I have been able to link both subforms by a common name but I also
want to link the two subforms by record so that when I am in:
SubForm 1
Record 1
and I sroll to record 2 then tab to SubForm 2 I want SubForm 2 to be on
record 2.

All help would be great.

Thanks all, Keith

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SynchronizedSubforms.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Keith" <(E-Mail Removed)> wrote in message
news:1444724F-30CF-4EAF-947B-(E-Mail Removed)...
> HELP PLEASE!!!
>
> I need to know how to link a subform to another subform inside a tab
> control. I have been able to link both subforms by a common name but I
also
> want to link the two subforms by record so that when I am in:
> SubForm 1
> Record 1
> and I sroll to record 2 then tab to SubForm 2 I want SubForm 2 to be on
> record 2.
>
> All help would be great.
>
> Thanks all, Keith

Mr. Carlson you're a life saver; thank you.

Cheers,
Keith

"Roger Carlson" wrote:

> On my website (www.rogersaccesslibrary.com), is a small Access database
> sample called "SynchronizedSubforms.mdb" which illustrates how to do this.
>
> --
> --Roger Carlson
> MS Access MVP
> Access Database Samples: www.rogersaccesslibrary.com
> Want answers to your Access questions in your Email?
> Free subscription:
> http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L
>
>
> "Keith" <(E-Mail Removed)> wrote in message
> news:1444724F-30CF-4EAF-947B-(E-Mail Removed)...
> > HELP PLEASE!!!
> >
> > I need to know how to link a subform to another subform inside a tab
> > control. I have been able to link both subforms by a common name but I
> also
> > want to link the two subforms by record so that when I am in:
> > SubForm 1
> > Record 1
> > and I sroll to record 2 then tab to SubForm 2 I want SubForm 2 to be on
> > record 2.
> >
> > All help would be great.
> >
> > Thanks all, Keith
>
>
>