I've thought about this one and apparently can't seem to find a
workable solution, although I'm sure there are a couple. Have two text
fields that can have values concurrently, but cannot have if one of
the fields contain a specific value of "S." I've tried using the
following code and variations to same on the BeforeUpdate Event on the
form. 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