Text Boxes

law

Registered User.
Local time
Today, 09:26
Joined
Feb 14, 2004
Messages
26
I have got a form in access & I have two seperate text boxes on this form. Is it possible to setup the boxes so that if data is entered into one box depending on the value entered data can automatically entered into the second text box, If anyone know's how to do it & they could show me I would be very greatful.

Thanks
 
law,

You can use the BeforeUpdate event of the first textbox:

Code:
If Me.TextBox1 = "SomeValue" Then
   Me.TextBox2 = "Something else"
End If

Or ...

If Me..TextBox1 = "SomeValue" Then
   Me.TextBox2.Visible = True
   Me.TextBox2.Enabled = True
End If

Wayne
 

Users who are viewing this thread

Back
Top Bottom