Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006

    Unanswered: ? Autofiltering Multiple Fields on User Input ?

    I'm not sure if this can be done in Access. I have a form with about 25 fields used to store information about the parts we distribute at work. My primary field is the part number. There is a certain amount of redundant information about different part numbers, such as material, customer, etc. I need to be able to start with a blank form, pick any field I want, and begin typing in data. As I do this, I want the field to query known records, and autocomplete as I type - similar to a combo box used to jump to a record. After Update, I want my records filtered for the data entered.

    I know about filter by form, and unfortunately this feature was not enough to satisfy my boss, who insists on a more user-friendly parts form.

    I attached a screener of my form to show what I'm trying to do. I appreciate any help!!

    Attached Thumbnails Attached Thumbnails partsform.gif  

  2. #2
    Join Date
    May 2004
    New York State

    Thumbs up

    Instead of making it "like a combobox," why don't you just use a series of comboboxes? For example, you can start with a new part number (text box, as it's unique); category (combo box: table/query, "widgets, legs, casters" for ex.). You picked widgets? OK, material (combo box, with all the materials you make widgets in). You picked plastic? OK, now size (combo box, with all the sizes your plastic widgets come in). You picked X" by Y"? OK, now description (text box, which will be pre-initialized with the words "Widget, plastic, X" by Y"" and will allow you to fill in the description). You can expand this ad infinitum, having one combo box after the other in series, with the Requery statement of the next combobox in the series in the AfterUpdate event of the previous textbox/combobox.

    It's really not hard. Try it.

    Hope this 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