Using expression builder to find lowest date

[MMcKenna]

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.

SELECT TOP 1 [3rdPartyList].CertEndDate
FROM 3rdPartyList
WHERE ((([3rdPartyList].SupplierRecord)=[Forms]![Primary]![SupplierRecord]))
ORDER BY [3rdPartyList].CertEndDate;

Thank you for your help,



Matt

[pbaldy]

Does this work as a control source?

=DMin("CertEndDate", "3rdPartyList", "SupplierRecord=" & [Forms]![Primary]![SupplierRecord])

which assumes a numeric data type for SupplierRecord.