Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    2

    Unanswered: Need help with search filed

    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.

  2. #2
    Join Date
    Jun 2006
    Posts
    2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •