OK Where am I going wrong on this string?
strWhere = "(CallDate = " & Format(Now(), conDateFormat) & " And " & " ( BodyCorporate = " & " Me.txtBodyCorporate " & ")"
Thanks all
OK Where am I going wrong on this string?
strWhere = "(CallDate = " & Format(Now(), conDateFormat) & " And " & " ( BodyCorporate = " & " Me.txtBodyCorporate " & ")"
Thanks all
Ok I worked it out:
strWhere = "(CallDate = " & Format(Now(), conDateFormat) & " And " & "[BodyCorporate] = """ & Me.txtBodyCorporate & """" & ")"