Displaying latest record on a form field

[Theman]

I have a button on a form called "Display Latest Notify Date" When clicked I would like it to display a form with the most recent date from a field in my Table called "Notify Date" I have tried using a query and playing around with date functions (e.g. Between Date() And Date()-7) but the best that I can get is list of dates and the most current usually does not show in the field. Is there a more accurate, better way to do this? Thanks.

 

[skiphooper]

Try this:
In your query field "Notify Date" in the
Criteria field put

>= Date()-7 And <= Date()

Should give you all records between those dates.

Skip