this ought to be easy, but I'm missing "something" (probably right in front of my nose)
I'm looking to return the contents of the field Version_ID in the most recent record base on the date in the field Version_Date of that record in the table tblVersionInf; and then assign it to a control property (which does work):
vtxt = DLookup("[version_id]", "tblVersionInfo", DMin("[Version_date]", "tblVersionInfo"))
me.lblVersionInfo.Caption = vtxt
all it's returning is the first record.
(if I change DMin to DMax... same result (so it has to be wrong!!))
with many thanks in advance,
mark