[AccessD] referencing form control

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