I have a report that opens using multiple where conditions. The following vba code works great:
acViewPreview, ,("[Source]<>' Non-Collaborative Facility' And ([CurrentAdmit]-[DischargeDate]>2)OR Isnull([Home]) And [Home]='no'")
I would like to include an alternate where condition that includes a wildcard where the reports pulls any record with K in the source title such as:
acViewPreview, ,("[Source] = ' "*" & k &"*" ' And ([CurrentAdmit]-[DischargeDate]>2)OR Isnull([Home]) And [Home]='no'")
I simply cannot get the code to execute correctly. I've never tried to utilize wildcards in vba and am not sure if it is possible. Any help would be great =)