Looks right, is customerID the right field/correct name on the form?

Is this form creating a new order when you open it? (and thus automatically making the most current order be today)

Try hardcoding it with a different customer, like CustomerID=1 or something and see what you get.

I know this is a dumb question, but is your orderdate field a date/time data type?  What you have should be working and also make sure that your OrderDate field does not have a default date in the table..

Note that [CustomerID], as used in your code, is the value from the currently selected record on your form.  Depending on how your form is set up, such as in a continuous form, the currently selected record may not give you the right value.  Since your form is based on a query as you said, consider using DMax inside the query, name the field [LastOrderDate], then use =[LastOrderDate] as the control source of your form field.

Thank you for your responses To answer Adam's question the form does not create a new record, display only, the field customerid is the correct one. tried hardcoding customerid of one I know does not have a record on 10/1/2024 no date shown. John's question, the orderdate field is a date/time field. Kevin's question The [customerid] is the customerID on the form, changed form to continous. Still get either no date or 10/1/2024, this date if from the table I am using last record on it 10/1/2024.

What if you do, in a query
SELECT TOP 1 OrderDate
FROM OrderProcessing
WHERE CustomerId = 1
ORDER BY OrderDate DESC;

The only ways you get 10/1/24 or no date is when DMax's criteria is always true or always false.  For instance:

     DMax("OrderDate", "OrderProcessing", True)

will always give you the max date of the whole table, which is 10/1/24 in your case.  And:

     DMax("OrderDate", "OrderProcessing", False)

will always return Null (the blank date that you see).

I can't think of a scenario why you are seeing this.  But the above is how you will get what you are seeing.  So something is fishy with your criteria in DMax.  Look into it.

Thank you for your response I will Try them  and let you know outcome. Tomorrow.

hello all just wanted to let you know that I finally got Died to do what  wanted it t do. Seems it was all on me miss used field names I felt really bad about the whole thing. All is good now. Again thank you all for your assistance.
JohnM