Putting the result of a query in a textbox

[gmeunier]

Dear all,

I have a table with 2 important fields :
COD_AE which is an ID number
COT_DATE which is a date
There can be several date by ID. There can not be the same ID with the same date twice.

My query asks for the latest date for one single ID.
I want that date to populate a textbox.

Has someone an idea?

Thanks in advance,

Gerald

 

[JoeMiller]

You can use the DMax to pull what you're looking for like so:

=DMax("[COT_DATE],"MyQueryName","[COD_AE]=[COD_AE]&quot

HTH Joe Miller
joe.miller@flotech.net