UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Enabling and Disabling a text box    
 
   
op66fantasie
post Nov 23 2010, 09:22 AM
Post #1

UtterAccess Member
Posts: 31



Hi,

I'm a newbie with vba and i'm tyring to accomplish something i believe should be very easy, but for some reason is not working.... I have a form with one combo box 'A' and one text box 'B'. In the 'On Current' event of the form, I'm trying to say that whenever a value is selected in A then text box B gets disabled, whenever A is blank, or Null, then B gets enabled. Heres my code:

----------------------------------------------
Private Sub Form_Current()

If Me.A = Null Then
B.Enabled = True
Else
B.Enabled = False
End If

End Sub
----------------------------------------------

What ends up happening is B stays disabled no matter what change is made. Is it something with the code or the event? Thx.
Go to the top of the page
 
+

Posts in this topic
- op66fantasie   Enabling and Disabling a text box   Nov 23 2010, 09:22 AM
- - rbianco   CODEIf IsNull(Me.A) Then   Nov 23 2010, 09:24 AM
- - op66fantasie   Thx!   Nov 23 2010, 09:35 AM


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 03:23 AM