S
swordsman8
Hello and thank you in advance.
I have a forms that limits the rows to be displayed from a Querry sheet from
what is picked in the form.
I have it all tied into a OK button on the Form.
I now have a comments field and my boss would like to use the comments field
to select certain data. EXAMPLE: type/select Laser and only the rows that
have laser in there comments field would be displayed.
If I write the following code into the Querry sheet it works fine but now I
need it to work in my form.
Code: Like "*" &[enter search key word] & "*"
In Where Clause
TableName.ColumnName Like "*" &[Selection]& "*"
Please help me write a code that will work in my form.
If you have questions or would like to look at my current code just let me
know.
Thank you,
Swordsman8
I have a forms that limits the rows to be displayed from a Querry sheet from
what is picked in the form.
I have it all tied into a OK button on the Form.
I now have a comments field and my boss would like to use the comments field
to select certain data. EXAMPLE: type/select Laser and only the rows that
have laser in there comments field would be displayed.
If I write the following code into the Querry sheet it works fine but now I
need it to work in my form.
Code: Like "*" &[enter search key word] & "*"
In Where Clause
TableName.ColumnName Like "*" &[Selection]& "*"
Please help me write a code that will work in my form.
If you have questions or would like to look at my current code just let me
know.
Thank you,
Swordsman8