G
Guest
As I update a record through a subform based on a Query of the Child Table…I
want the new current date to be placed in an assigned field in the Parent
table. I added a new field in the Parent table (a date field)…I pulled this
field to my main form in a section above the subform. In the control source
for this field I have inserted the following:
=DMax("[ReadOn]","[Child Query]","[ParentTable_ID] = " & [ID])
This displays the new current date in the text box for the field on the
form. The date displays correctly when updated…..but the value does not move
into the Parent Table. Anyone have an idea? Thank you.
want the new current date to be placed in an assigned field in the Parent
table. I added a new field in the Parent table (a date field)…I pulled this
field to my main form in a section above the subform. In the control source
for this field I have inserted the following:
=DMax("[ReadOn]","[Child Query]","[ParentTable_ID] = " & [ID])
This displays the new current date in the text box for the field on the
form. The date displays correctly when updated…..but the value does not move
into the Parent Table. Anyone have an idea? Thank you.