default value = most recent date

M

miss031

I want to have a combo box that looks up a stored date, that which, when
selected, fitlers the records by that date, but I would like the default
value to be the most recent date stored. How do I set this default? The
dates are stored in a table.
 
A

Al Campagna

Miss031,
Try...
=DMax("[YourDate]","tblYourTable")
as the default for the combo.
 
Top