I have a form I'm running this Where Condition in a macro using a hidden txt box to produce my results: .
=[MailingAdd_lbl] Like [Forms]![SearchForm]![txtAddWild]
I'd like to be able to search a second field to produce a single report showing matching results from BOTH fields
I've tried the OR operator to no avail... ie:
=[MailingAdd_lbl] Like [Forms]![SearchForm]![txtAddWild] OR [PhysicalAdd_lbl] Like [Forms]![SearchForm]![txtAddWild]
I've also tried adding the second expression as a secondary action but it only produces the results from the second expression.
I also took a stab at inserting VBA code but before killing an hour or two of my afternoon I thought I'd ask the experts.
Thanks for your input!!