Before Update Event for Text Box Contents

[Dalan]

I need assistance regarding how to structure code for preventing
values being entered into three text fields.

Although the two of the three text fields can have values
concurrently, it is not permitted if one of the fields has a specific
value of "S", I've tried using the following code and variations to
same on the BeforeUpdate Event on the form, but so far no go. Any
assistance to resolve this issue will be appreciated. Thanks, Dalan

If Not IsNull(Me!Display1) And Not IsNull(Me!Display2) Then
If Me!Stock = "S" Then
MsgBox "You cannot have both a Display Case and a (S) Stock
code. You must choose one or the another.", vbExclamation

Me!Stock.SetFocus
Cancel = True
End If
End If

[Wayne Morgan]

I believe you may want Or instead of And in the first If statement. This
would result in checking to see if Me!Stock="S" if either Display1 or
Display2 had a value. You could probably make it a single statement (note
the parenthesis):

If (Not IsNull(Me!Display1) Or Not IsNull(Me!Display2)) And Me!Stock = "S"
Then

What might be easier to read would be (and would use And instead of Or)

If Not (IsNull(Me!Display1) And IsNull(Me!Display2)) And Me!Stock = "S" Then

--
Wayne Morgan
Microsoft Access MVP
"Dalan" <ot***@safe-mail.net> wrote in message
news:50**************************@posting.google.c om...

I need assistance regarding how to structure code for preventing
values being entered into three text fields.

Although the two of the three text fields can have values
concurrently, it is not permitted if one of the fields has a specific
value of "S", I've tried using the following code and variations to
same on the BeforeUpdate Event on the form, but so far no go. Any
assistance to resolve this issue will be appreciated. Thanks, Dalan

If Not IsNull(Me!Display1) And Not IsNull(Me!Display2) Then
If Me!Stock = "S" Then
MsgBox "You cannot have both a Display Case and a (S) Stock
code. You must choose one or the another.", vbExclamation

Me!Stock.SetFocus
Cancel = True
End If
End If

[Dalan]

Well, nothing seems to work whether And Or, or over a dozen different
themes of this expression. What could be wrong? Anyone's input would
be welcomed. Thanks.
"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:<EV*******************@newssvr33.news.prodigy .com>...

I believe you may want Or instead of And in the first If statement. This
would result in checking to see if Me!Stock="S" if either Display1 or
Display2 had a value. You could probably make it a single statement (note
the parenthesis):

If (Not IsNull(Me!Display1) Or Not IsNull(Me!Display2)) And Me!Stock = "S"
Then

What might be easier to read would be (and would use And instead of Or)

If Not (IsNull(Me!Display1) And IsNull(Me!Display2)) And Me!Stock = "S" Then

--
Wayne Morgan
Microsoft Access MVP
"Dalan" <ot***@safe-mail.net> wrote in message
news:50**************************@posting.google.c om...

I need assistance regarding how to structure code for preventing
values being entered into three text fields.

Although the two of the three text fields can have values
concurrently, it is not permitted if one of the fields has a specific
value of "S", I've tried using the following code and variations to
same on the BeforeUpdate Event on the form, but so far no go. Any
assistance to resolve this issue will be appreciated. Thanks, Dalan

If Not IsNull(Me!Display1) And Not IsNull(Me!Display2) Then
If Me!Stock = "S" Then
MsgBox "You cannot have both a Display Case and a (S) Stock
code. You must choose one or the another.", vbExclamation

Me!Stock.SetFocus
Cancel = True
End If
End If

[Wayne Morgan]

Ok, then I'll need a better explanation of "doesn't work". What is it doing,
not doing, and is supposed to do?

--
Wayne Morgan
MS Access MVP
"Dalan" <ot***@safe-mail.net> wrote in message
news:50**************************@posting.google.c om...

Well, nothing seems to work whether And Or, or over a dozen different
themes of this expression. What could be wrong? Anyone's input would
be welcomed. Thanks.

[Bas Cost Budde]

Dalan wrote:

I need assistance regarding how to structure code for preventing
values being entered into three text fields.

Is the Enter event of these controls suitable for this?

--
Bas Cost Budde
http://www.heuveltop.nl/BasCB