There is an invalid use of the . (dot) or ! operator or invalid parentheses

[MikeMairangi]

Any help with this would be much appreciated.



I am trying to create a simple conditional statement to prevent the triggering of a append query if the value of the submitted textboxes are "" or null. I have the following code within the update button but I get the following error

" There is an invalid use of the . (dot) or ! operator or invalid parentheses"

Code as follows;

Private Sub B_LogEvent_Click()
On Error GoTo Err_B_LogEvent_Click
DoCmd.SetWarnings False
Dim stDocName As String
If (Forms![ACTIVITY].AddEvent = "") Then
MsgBox ("You need to enter the event details before logging the event")
Else
stDocName = "Q-Add-Event"
DoCmd.OpenQuery stDocName, acNormal, acEdit
End If
Exit_B_LogEvent_Click:
Me.Refresh
DoCmd.SetWarnings True
Exit Sub
Err_B_LogEvent_Click:
MsgBox Err.Description
Resume Exit_B_LogEvent_Click

End Sub

I know its the

If (Forms![ACTIVITY].AddEvent = "") Then

line causing the problem but cannot see what the issue is.

[ajetrumpet]

you're using an action in a conditional statement. Obviously that won't work. Moreover, actions rarely give return values, which you've specified as "". And further than that, does access even have a ".addevent" action?

[MikeMairangi]

AddEvent is the name of the textbox. Have I used a reserved name for the textbox?

[desk4tbc]

Try If (Forms![ACTIVITY]!AddEvent = "") Then If AddEvent is a textbox otherwise Access is thinking it is an action or a property.

[boblarson]

No parens needed

If Forms![ACTIVITY].AddEvent = "" Then

[MikeMairangi]

Changed it to

If Forms![ACTIVITY].AddEvent = "Call" Then

and still get the same error message, don't understand what the issue is.

[rpeare]

if activity is the name of your form and addevent is the name of a field try

me.addevent = "call"

or

[forms]![activity]![addevent] = "call"

[MikeMairangi]

I've sorted this out. AddEvent is actually a combo box and whilst the drop downs display the text value the actual returned value is an integer so

If IsNull([Forms]![ACTIVITY]![AddEvent]) = True

Worked. Thanks for all the input!