Nicholson, Karen
cyx5 at cdc.gov
Fri Sep 10 14:18:49 CDT 2004
This code works and compiles just fine:
If ([Forms]![frmASRSSectInit].[RequestType] <> "site audit" _
And [Forms]![frmASRSSectInit].[Status] = "Open" _
And [Forms]![frmASRSSectInit].[ysnCBRNTest] = 0 _
And Not IsNull([Forms]![frmASRSSectInit].[ASSectCompletedDate]))
_
And IsNull([Forms]![frmASRSSectInit].[CBRN_FinalTestReport]) _
Then
[Forms]![frmASRSSectInit].[ysnCBRNTest] = -1
End If
However, there is a numeric field in my table and on my form named:
Section. It must be a reserved word, because when I change the code to
specify that the section should equal 2, I get a compile error, argument
not optional. Yikes! A Friday headache is upon me. What ever can I do
to get around this? I can't change the field name as it is an SQL
backend and the damn would break.
If ([Forms]![frmASRSSectInit].[RequestType] <> "site audit" _
And [Forms]![frmASRSSectInit].[Status] = "Open" _
And [Forms]![frmASRSSectInit].[ysnCBRNTest] = 0 _
And [Forms]![frmASRSSectInit].[Section] = 1 _
And Not IsNull([Forms]![frmASRSSectInit].[ASSectCompletedDate]))
_
And IsNull([Forms]![frmASRSSectInit].[CBRN_FinalTestReport]) _
Then
[Forms]![frmASRSSectInit].[ysnCBRNTest] = -1
End If
Karen Nicholson
National Laboratory
Xerox Global Services