Dmax

[Tony Cannizzo]

Access 2007:
Have an Unbound Text Box on a Form.
Trying to set the Default Value to the most recent date in a table called
Transactions.
The field in Transactions is called txnDate.

=DMax("[txnDate]","Transactions") as the Default Value returns #Error on the
form control.

Am I missing something here?

Thanks
tc

 

[Jerry Whittle]

If you want it to display the latest date, put in in the Control Source of
that text box.

 

[Tony Cannizzo]

Looks like this mdb is corrupted because it works correctly in a new database
as Default Value

If you want it to display the latest date, put in in the Control Source of
that text box.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Access 2007:
Have an Unbound Text Box on a Form.
Trying to set the Default Value to the most recent date in a table called
Transactions.
The field in Transactions is called txnDate.

=DMax("[txnDate]","Transactions") as the Default Value returns #Error on the
form control.

Am I missing something here?

Thanks
tc