Hey Everyone,
Access 2000 DB.
-Input form based on table with info about a specific project. Various date fields, specifically one "ProjectedHardwareShipDate", other date fields calculate based on this date.
-Subform based on query from same table that lists any projects related to parent form Project. These projects are related by the use of two fields. "TID" and TIDRef" one to many.
I can duplicate a project in the main form and assign the TID as TIDRef in the new project with a new TID. Where I am having trouble is changing the date in "ProjectedHardwareShipDate", in the Parent form, and having that date change in all records in the subform.
IF me.subform!TIDRef=me.parent!TID then
.......??
I hope this makes sense.
RoCoPe
"You need it to do what?"
Access 2000 DB.
-Input form based on table with info about a specific project. Various date fields, specifically one "ProjectedHardwareShipDate", other date fields calculate based on this date.
-Subform based on query from same table that lists any projects related to parent form Project. These projects are related by the use of two fields. "TID" and TIDRef" one to many.
I can duplicate a project in the main form and assign the TID as TIDRef in the new project with a new TID. Where I am having trouble is changing the date in "ProjectedHardwareShipDate", in the Parent form, and having that date change in all records in the subform.
IF me.subform!TIDRef=me.parent!TID then
.......??
I hope this makes sense.
RoCoPe
"You need it to do what?"
