Results 1 to 3 of 3
  1. #1
    IAFerrari is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2015
    Posts
    15

    Creating a Search box on a header on a form

    I am creating a search box on the header. I want to search for cart number then that cart will show up with all of its information. I created a button and a text box and named them. What would the code be to do this.
    please can you do detailed steps as been a while since working in access.
    thanks


    john

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

  3. #3
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 8 Access 2013
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    705
    Quote Originally Posted by IAFerrari View Post
    I am creating a search box on the header. I want to search for cart number then that cart will show up with all of its information. I created a button and a text box and named them. What would the code be to do this.
    please can you do detailed steps as been a while since working in access.
    thanks
    john
    John,

    There is a combo box wizard (option 3) that will do what you need. It will write all the code for you. The advantage to a comb box is that it can validate the chart number for you.

    At least try it and look at the code it created.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 09-02-2015, 03:00 PM
  2. Help creating a search form
    By ttn022191 in forum Sample Databases
    Replies: 5
    Last Post: 09-26-2014, 01:39 PM
  3. Creating a Search Form
    By midnight_puppy_2303 in forum Forms
    Replies: 5
    Last Post: 08-04-2014, 09:29 AM
  4. Creating a "search" field in the header
    By MissLotus in forum Forms
    Replies: 9
    Last Post: 07-24-2013, 03:52 AM
  5. Need help in creating Search Form
    By bnar in forum Forms
    Replies: 2
    Last Post: 06-05-2012, 12:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums