Recent content by istjustoldcardboard

Thank you! This did the trick. I had to modify a bit because of the foreign key but this is what i am using: =DLookUp("[curCardBVPrice]","tblChecklistPricing","[fkCardID] = " & [Forms]![frmChecklistCard]![pkCardID] & " AND dtmCardPricingC=#" &...

In a field on a form I am trying to retrieve the latest pricing information based on the newest date. tblChecklistPricing pkCardID curCardBVPrice dtmCardPricingC 585 1.00 4/14/2019 586 1.25 4/14/2019 588 1.25 4/14/2019 585 1.50 4/16/2019 So in the example above, I would like to display "1.50"...