T
tjdaly
I am trying to create a form that will be used for design professionals. The
form will continue general project information, this will be the Parent,
[Design Master] Form. I am controlling this form with a combo box that is
selecting the data to be displayed from the underlying query. Such as
Project Name, Sales Person etc.
I am attempting to add a sub form [Design Time Tracking] that is for the
designer to enter their time. So effectively a time tracking sub form. This
form can not be controlled by the parent because it will find all of the past
time sheets, it should be in data entry mode. My struggle is that I do not
want the parent to control the sub form, however I do want the Project Name
and the Designer to be the default value in the sub form based on the project
selected in the parent form. Once the project name and designer are
displayed the designer can then just enter their hours and task code. Not
sure it matters but currently the Projectnamedesign fireld from the Time
Tracking Table is from a combo box.
I will also have two other sub forms in this that will be controlled by the
parent, one displaying hours to date versus estimate and the other showing
project dates and tasks.
Any help in setting the default value from the parent would be greatly
appreciated.
Thanks,
form will continue general project information, this will be the Parent,
[Design Master] Form. I am controlling this form with a combo box that is
selecting the data to be displayed from the underlying query. Such as
Project Name, Sales Person etc.
I am attempting to add a sub form [Design Time Tracking] that is for the
designer to enter their time. So effectively a time tracking sub form. This
form can not be controlled by the parent because it will find all of the past
time sheets, it should be in data entry mode. My struggle is that I do not
want the parent to control the sub form, however I do want the Project Name
and the Designer to be the default value in the sub form based on the project
selected in the parent form. Once the project name and designer are
displayed the designer can then just enter their hours and task code. Not
sure it matters but currently the Projectnamedesign fireld from the Time
Tracking Table is from a combo box.
I will also have two other sub forms in this that will be controlled by the
parent, one displaying hours to date versus estimate and the other showing
project dates and tasks.
Any help in setting the default value from the parent would be greatly
appreciated.
Thanks,