IF statement to enable two text boxes (1 Viewer)

S

scubadiver007

Registered User.
Local time
Today, 12:11
Joined
Nov 30, 2010
Messages
317
This ain't workin'

Code: 
If Me.Gender = "male" Then
Me.MaternitySDate.Enabled = False And Me.MaternityDate.Enabled = False
ElseIf Me.Gender = "female" Then
Me.MaternitySDate.Enabled = True And Me.MaternityDate.Enabled = True

It must be something simple...
 
pr2-eugin

pr2-eugin

Super Moderator
Local time
Today, 20:11
Joined
Nov 30, 2011
Messages
8,494
Try this..
Code: 
If Me.Gender = "male" Then
    Me.MaternitySDate.Enabled = False
    Me.MaternityDate.Enabled = False
Else
    Me.MaternitySDate.Enabled = True 
    Me.MaternityDate.Enabled = True
End If
And is a Logical Operator, not a Concatenation operator.. Also, I believe there are only two options for Gender so there is no need for an ElseIf.. as it is waste of computational space and time..
 
S

scubadiver007

Registered User.
Local time
Today, 12:11
Joined
Nov 30, 2010
Messages
317
Useful to learn, thanks.
 
You must log in or register to reply here.

Similar threads

O
New line on IF Statement
Replies
9
Views
439
arnelgp
arnelgp
M
Solved F11 - Disable or not.
2
Replies
32
Views
1,289
Marshall Brooks
M
T
Solved Enable button if file attached
Replies
4
Views
226
theDBguy
theDBguy
C
Check Box IIF Statement
Replies
7
Views
375
Pat Hartman
P
Mylton
Solved Difficulty with login and permission
Replies
16
Views
1,014
Mylton
Mylton

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom