Getting a compile error 1

[beverlee]

I'm using the following piece of code and getting a compile error.

If Me.[LatestNeg]![latestnegtest] < Me.LatestPos![latestpostest] Then Me.BaselineNeg.Value = ""
ElseIf IsNull(Me.BaselineNeg) And Me.LatestNeg!latestnegtest > Me.LatestPos![latestpostest] Then
Me.BaselineNeg = Me.LatestNeg![latestnegtest]
End If

It's not liking the code right after 'And'. I need both of those conditions to be true in order for it to run.

Any help is greatly appreciated!

 

[PHV]

Correct syntax:
If Me.[LatestNeg]![latestnegtest] < Me.LatestPos![latestpostest] Then
Me.BaselineNeg.Value = ""
ElseIf IsNull(Me.BaselineNeg) And Me.LatestNeg!latestnegtest > Me.LatestPos![latestpostest] Then
Me.BaselineNeg = Me.LatestNeg![latestnegtest]
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[beverlee]

Thank you!!!