Hi, i am new to MS Access and learning it. I created a MS access form from my inventory report. I have all my inventory data coming up. I like to add a Search button in the form so user can search the inventory by part number. How can I add a search button, which will search the part number and will display all the information related to that part number!!. Thanx in advanced.
Sounds like you need to add a query that will allow you to search by part number. Create a query using the table with the inventory and in the part number field, use the syntax in the criteria field Like "*" & [Enter Part Number] & "*". That will allow you to enter a partial part number with either numbers at the beginning or end. For example, if you have a part number such as 0423412, you could enter 0423 and it will pull up every item with 0423 in it. If you don't like this kind of search, just do the Like [Enter Part Number]. Hope that helps.