My Assistant
|
|
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. |
|
|
|
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![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 18th June 2013 - 03:23 AM |