Dmax

  • Thread starter Thread starter Tony Cannizzo
  • Start date Start date
T

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
 
If you want it to display the latest date, put in in the Control Source of
that text box.
 
Looks like this mdb is corrupted because it works correctly in a new database
as Default Value

Jerry Whittle said:
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.


Tony Cannizzo said:
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
Click to expand...
Click to expand...
 
Back
Top