Too much information to place on one form with subforms so I created a
form and placed a tab control on it with three tabs. Primary
Table/Form on top tab, form 2 on tab 2, form three on tab 3.
They just do not sychronize up so I am missing a concept here.
I have form 1 with a tab control on it, then the three data entry forms
on the tab control. The form with the tab control on it is using the
primary record source as is the Primary form and they are linked on the
Primary key. What am I doing wrong?
If you mean something else, can in explain more fully?
--
--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/wa.exe?SUBED1=ACCESS-L
"Jeff C" <jpco...@hotmail.com> wrote in message
news:1159969135.3...@b28g2000cwb.googlegroups.com...
I am baffled by what was happening, the form with the tab control show
all the records available with the navigation button, but only 1 empty
record showed on the forms on the tab control, in other words I could
not navigate through all the records on the tab control.
What I have done now to get this working was to place the tab control
on my primary form with the two sub forms on two tabs. This is working
well but the end users naturally have their screen resolution turned
down so they cannot see the botoom area of the form where the subforms
are without scrolling. This was my main reason for trying to put all
three forms on tabs.
Calling the form where the three tabs resided "main", Main to primary
form tab 1 was primary key to primary key, Primary form tab1 to sub1tab
2 was primary key to child key, Primary form tab 1 to sub2 tab 3 was
primary key to child key.
Thanks for your help
I am baffled by what was happening, the form with the tab control show
all the records available with the navigation button, but only 1 empty
record showed on the forms on the tab control, in other words I could
not navigate through all the records on the tab control.
What I have done now to get this working was to place the tab control
on my primary form with the two sub forms on two tabs. This is working
well but the end users naturally have their screen resolution turned
down so they cannot see the botoom area of the form where the subforms
are without scrolling. This was my main reason for trying to put all
three forms on tabs.
Calling the form where the three tabs resided "main", Main to primary
form tab 1 was primary key to primary key, Primary form tab1 to sub1tab
2 was primary key to child key, Primary form tab 1 to sub2 tab 3 was
primary key to child key.
Thanks for your help
Roger Carlson wrote:
--
--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/wa.exe?SUBED1=ACCESS-L
"Jeff C" <jpco...@hotmail.com> wrote in message
news:1159972424....@c28g2000cwb.googlegroups.com...