Getting a date from Query to Text box

[pdwalke4]

I have a query that returns the latest order date of a customer (on a sub form). I want to get the value from this query into the main form.

The idea being that everytime the customer adds a new order this value would be updated.

How do i do this?

 

[neileg]

Probably easier to use the DMax() function than using a query. It would use the same data but returns a single value which is more appropriate for populating a single text box.

 

[pdwalke4]

Whats the Dmax function? not heard of that one.

 

[neileg]

Have a look in MS Access help for starters?