I thought this was going to be simple but it is not coming together. I have a textbox on a form that was tied into my table as a control source. No issue there. I then changed the control source for the textbox to:
This gets me the value I am looking for which is derived from the lowest date from a subform list. The problem I have now is that the value is not tied into the table.
=DMin("CertEndDate","3rdPartyList","SupplierRecord=" & Forms!Primary!SupplierRecord)
I tried changing the textbox control source back to the table field and adding this to an event but it was a no go.
Essentially I need to take the lowest date from a subform, display it on the parent form and write that value to the form source table.
=Forms!Primary!EarliestExpiration=DMin("CertEndDate","3rdPartyList","SupplierRecord=" & Forms!Primary!SupplierRecord)
Any thoughts on a simple way to do this?