[AccessD] Text Box Default Value

Chester, 

Try using a domain aggregate function:

=DMin("[ProductionDate]","tbl Manifold Production") 

Hope this helps . . .

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Wednesday, September 19, 2007 12:53 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Text Box Default Value

I an using the following expression to set the default value of a text
box on a form. The text box displays nothing. What might I be doing
wrong? Thanks

 

=Min([tbl Manifold Production]![ProductionDate])

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com