I have a table with 14 columns, one of those is "Status".
How can I perform search function (with a keyword), using all fields of this table and only search the records where the "Status" = "WIP"?
Thanks in advance.

THe only way i know to approach that would be to create a form from that table...do a search function on this.

Have a look at Access help using the keyword 'bookmark' it gives you some example code which would work for this

Yes, I have already created a form that table and create a "search" button, but than it will search the entire table, not only the records where the "Status"="WIP"