A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

enable/disable text box based on 3 combos



 
 
Thread Tools Display Modes
  #1  
Old May 14th, 2010, 06:57 PM posted to microsoft.public.access.forms
Mikhail Bogorad
external usenet poster
 
Posts: 7
Default enable/disable text box based on 3 combos

hi
i have 3 combos (user chooses Yes or No from a drop down) and a text
field that is disabled by default and i'm trying to enable if either
one of these 3 combos has "NO" value.

So here is what i have and it's not working so far.

Private Sub Form_current()
If Me.Combo1 = "NO" Then
Me.Text.Enabled = True
Else
If Me.Combo2 = "NO" Then
Me.Text.Enabled = True
Else
If Me.Combo3 = "NO" Then
Me.Text = True
Else
Me.Text.Enabled = False
End If
End If
End If

End Sub

Any suggestions?
Thanks
  #2  
Old May 14th, 2010, 10:02 PM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default enable/disable text box based on 3 combos

Text is a Reserved Word in Access and is, in fact, the name of a textbox
property, and

Me.Text.Enabled = True

may confusing the Access gnomes! I'd modify the name of the textbox.

Also, your code for thee third combobox is

If Me.Combo3 = "NO" Then
Me.Text = True

and I expect you mean it to be like the rest

If Me.Combo3 = "NO" Then
Me.Text.Enabled = True

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1

  #3  
Old May 14th, 2010, 10:44 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default enable/disable text box based on 3 combos

On Fri, 14 May 2010 10:57:58 -0700 (PDT), Mikhail Bogorad
wrote:

hi
i have 3 combos (user chooses Yes or No from a drop down) and a text
field that is disabled by default and i'm trying to enable if either
one of these 3 combos has "NO" value.

So here is what i have and it's not working so far.

Private Sub Form_current()
If Me.Combo1 = "NO" Then
Me.Text.Enabled = True
Else
If Me.Combo2 = "NO" Then
Me.Text.Enabled = True
Else
If Me.Combo3 = "NO" Then
Me.Text = True
Else
Me.Text.Enabled = False
End If
End If
End If

End Sub

Any suggestions?
Thanks


A single line will do it:

Me.Text.Enabled = (Me.Combo1 = "NO" OR Me.Combo2 = "NO" OR Me.Combo3 = "NO")

Either your code or mine assumes that the *bound column* of the combo contains
the text string NO; if the combo has a concealed numeric ID field as the bound
column (which the wizard will probably generate for you) you'll need to either
test for that numeric value or use the combo's Column() property to select the
correct column. It's zero based so Me.Combo2.Column(1) would be the second
column.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.