Here is my current query

SELECT Central2000.Last, Central2000.First, Central2000.Part, Central2000.Descript, Central2000.ID1, Central2000.Status, Central2000.Loaned, Central2000.Email
FROM Central2000
WHERE(((Central2000.Part) Like '::Part::%'));

Any input would be appreciated.

Thanks

SELECT Central2000.Last, Central2000.First, Central2000.Part, Central2000.Descript, Central2000.ID1, Central2000.Status, Central2000.Loaned, Central2000.Email
FROM Central2000
WHERE(((Central2000.Part) Like '::Part::%')) OR (((Central2000.Part) Like '::Part2::%')) OR (((Central2000.Part) Like '::Part3::%'));

Make sure your form boxes are named the same as above!

Maybe I didn't ask the right question-- when I used your suggestion it returns everything if I use something under part2 since I am using the % so a partial part number can be entered-- What I am looking for is to be able to look up a part number with that all fit a status of IN or Out which is a field in the database. So I am actually wanting to have the search based on two variables.

Thanks in advance for your help.

(Central2000.Part Like '::Part::%' AND Status='In') ?