Getting a date from Query to Text box

pdwalke4

Registered User.
Local time
Today, 13:25
Joined
Mar 10, 2007
Messages
13
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?
 
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.
 
Whats the Dmax function? not heard of that one.
 
Have a look in MS Access help for starters?
 

Users who are viewing this thread

Back
Top Bottom