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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Updating inventory levels 0
Using Start Date and End Date in Query 5
stock in hand 3
Looking for Dmax function in Expression Builder 7
Default Value as last date in a table? 5
Conserving values in Sub & SubSub forms. 1
Transaction Record 2
Graph based on a Query? 4

Back
Top