Retreiving latest record

[JeffreyDavid]

I have a table with 3 fields, that automatically updates 1 of the 3 fields on a daily basis, exchange rate. On a form I have a text box that I want to display that newest exchange rate from the daily updating table. So each time I open this form, the text box will check the exchange rate and post the newest rate.

Anyone?

 

[ghudson]

Check the help files for the DLookup() and/or DMax() functions.

HTH