R
rattler0812
I am sure the subject line is somewhat confusing. But here is my dilema. I
am tracking the training of some people through various phases. I have set
up a master table of their information. I, unfortunately, have to manually
copy their "TraineeID" into the various tables of the training phases that
they will go through. So far, so no real difficulties there (Unless there is
a command that I can program into a button that will automatically create
their record in the tables for each training phase to make things easier).
What I currently have is a main form with several subforms linked via
TraineeID. Each subform is one phase of training and has their own
appropriate control boxes for dates of when particular pieces of training are
completed. The main form has a date control box that is associated with each
subform. When each subform has had every control box filled, the associated
master form control box should be automatically filled. So, to visualize,
here's what I mean. Main form has control A-D. Control A-D are associated
with Subforms A-D. When all control boxes in Subform A are filled, the main
form Control A should be automatically filled. Now, since the date that goes
into the main form control is also stored in the table, how do I get that to
save as the control without changing the control from a Bound control to an
Unbound? If posting of screenshots will help in understanding, please let me
know and I can provide those.
Rattler
am tracking the training of some people through various phases. I have set
up a master table of their information. I, unfortunately, have to manually
copy their "TraineeID" into the various tables of the training phases that
they will go through. So far, so no real difficulties there (Unless there is
a command that I can program into a button that will automatically create
their record in the tables for each training phase to make things easier).
What I currently have is a main form with several subforms linked via
TraineeID. Each subform is one phase of training and has their own
appropriate control boxes for dates of when particular pieces of training are
completed. The main form has a date control box that is associated with each
subform. When each subform has had every control box filled, the associated
master form control box should be automatically filled. So, to visualize,
here's what I mean. Main form has control A-D. Control A-D are associated
with Subforms A-D. When all control boxes in Subform A are filled, the main
form Control A should be automatically filled. Now, since the date that goes
into the main form control is also stored in the table, how do I get that to
save as the control without changing the control from a Bound control to an
Unbound? If posting of screenshots will help in understanding, please let me
know and I can provide those.
Rattler