Charlotte Foust
cfoust at infostatsystems.com
Tue Feb 3 10:17:51 CST 2004
Just drop the .Text property and use Me.state or Me.state.Value. You can only refer to the Text property of a control that has the focus in Access. Charlotte Foust -----Original Message----- From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] Sent: Tuesday, February 03, 2004 7:22 AM To: accessd at databaseadvisors.com Subject: [AccessD] referencing form control I can never remember this -- how do I reference a control ? on VB6 it would have been this way -- If Me.state.Text = "CA" Then stDocName = "screeningCA" Else stDocName = "screening49" End If ----------------------------------------- Get Breaking News from CNN, ABC, NBC, CBS Now. http://www.xuppa.com/news/?link=webmail _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com