Hi
I am using
If IsNull(Forms![Summary form]!Combo0.Value) Then
strSystem = " Like ""*"" "
Else
strSystem = "='" & [Forms]![Summary form]![Combo0].Value & "' "
End If
The code is part of a module to create an SQL statement which updates the criteria in a query. The above code works fine and puts Like "*" as the criteria in the query, but I need to add Or Is Null so it would look like Like "*" Or Is Null. I have tried many combinations in the = " Like ""*"" " part of the code but it always errors. Can anyone help!
I am using
If IsNull(Forms![Summary form]!Combo0.Value) Then
strSystem = " Like ""*"" "
Else
strSystem = "='" & [Forms]![Summary form]![Combo0].Value & "' "
End If
The code is part of a module to create an SQL statement which updates the criteria in a query. The above code works fine and puts Like "*" as the criteria in the query, but I need to add Or Is Null so it would look like Like "*" Or Is Null. I have tried many combinations in the = " Like ""*"" " part of the code but it always errors. Can anyone help!
