G
Guest
Hi, I've posted a few times on this and thought I finally had it figured
out. I have a main table (tbl_PNG_Main) and a subtable (tbl_Date_Detail).
Each main record has to go through any number of actions that all have
different action dates and due dates. There are 7 possible actions and each
record will have at least 2 but could have up to 7.
tbl_Date_Detail consists of:
Date_ID (PK)
PNG_ID (FK to main table)
Date_Type (the 7 possible actions)
Action_Date
Due_Date
I built a Main Form that consists of tabs and then built 7 subforms (one for
each action). Each subform has a default value in the Date_Type of the
appropriate action and this field is not visible so that it cannot be edited.
The user can enter the Action &/or Due Dates and then there are other
calculated dates on the form (ie. send reminder). I have this all set up and
when you fill out a record it stores the correct information back to the
detail table. However, the data does not stay in the form, when you go back
to the record it has the first due date entered stored in all the due dates.
I have tried putting in code on the On Current and the After Update event to
requery each subform (Me.Subfrm_Abandon.Form.Requery etc.) however, it
doesn't seem to work. Any idea what I'm doing wrong? Thanks a lot!
out. I have a main table (tbl_PNG_Main) and a subtable (tbl_Date_Detail).
Each main record has to go through any number of actions that all have
different action dates and due dates. There are 7 possible actions and each
record will have at least 2 but could have up to 7.
tbl_Date_Detail consists of:
Date_ID (PK)
PNG_ID (FK to main table)
Date_Type (the 7 possible actions)
Action_Date
Due_Date
I built a Main Form that consists of tabs and then built 7 subforms (one for
each action). Each subform has a default value in the Date_Type of the
appropriate action and this field is not visible so that it cannot be edited.
The user can enter the Action &/or Due Dates and then there are other
calculated dates on the form (ie. send reminder). I have this all set up and
when you fill out a record it stores the correct information back to the
detail table. However, the data does not stay in the form, when you go back
to the record it has the first due date entered stored in all the due dates.
I have tried putting in code on the On Current and the After Update event to
requery each subform (Me.Subfrm_Abandon.Form.Requery etc.) however, it
doesn't seem to work. Any idea what I'm doing wrong? Thanks a lot!