[AccessD] Text Box Default Value

Instead of using the default value property, try this in the forms Load
event:

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

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Wednesday, September 19, 2007 2: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