I have a small database that contains our suppliers. Each supplier main form has a subform that lists their certifications. Each certification has a valid until date. What I am trying to do is pull out the date that is ending soonest and using it as a recall date, keep in mind that there could be no certification and dates or there could be many, depending on the supplier. I have been able to do this with a query but I cannot get it to populate a textbox on the supplier main form. Below is my query that gives me the results I want. How do I get these results into a textbox? Can I accomplish this with expression builder? I would appreciate any thoughts.
Code:
SELECT TOP 1 [3rdPartyList].CertEndDate
FROM 3rdPartyList
WHERE ((([3rdPartyList].SupplierRecord)=[Forms]![Primary]![SupplierRecord]))
ORDER BY [3rdPartyList].CertEndDate;
Thank you for your help,
Matt