I've been scouring all over trying to find a way to use a multiple line text box to return query with ALL the criteria I want for a particular field.
I have a form: frmAWBsearch
Which has a text box named "AWBS" with the enter behavior set to "New Line in Field". I then have a command button opening my query.
On my query qryAWBsearch
Under my AWB field I entered the crieteria "[forms]![frmAWBsearch]![AWBS]"
I try to enter multiple values in the fiel "AWBS" on my form such as:
and I want the query to return the results for all those records, but it will only work if I enter one record! If I enter multiple records it comes out blank. I have been looking around and have seen that people can do this from a combo box with multiple selections, but i'm stumped as to how I could make this work.
Any help would be appreciated.