Combo Box Filter

2013-04-14  Source: Original Site  Category:Access  Views:1 


I am trying to filter a form using a combo box

What i have is a form to display mp3 files on a server and i want to have about 10 combo boxes to filter the results, the combo boxes are named selected_type_1 through to selected_type_10 we have a table called mp3s that has 10 fields for the filter to be associated with so we have a mp3 with 10 words that relate to it i want to be able to select a word in the first list and filter the results if the word is listed in any of the 10 fields in the table....

If it would be possible i was thinking of replacing the combo boxes with a list box and being able select various words and searching all the feilds for each of these words

i have tried with some of the examples on the forum but not having much luck as i am new to access..

I have attached a copy of the file if it helps

Related articles
  • Combo Box Filter 2013-04-14

    I am trying to filter a form using a combo box What i have is a form to display mp3 files on a server and i want to have about 10 combo boxes to filter the results, the combo boxes are named selected_type_1 through to selected_type_10 we have a table

  • Filtering with Multiple Combo Boxes 2014-04-11

    Currently I have a form (tblTaxonomy) with 6 combo boxes that each will filter the results on a Subform (tblTaxonomysubform). Via this: Private Function RunFilter() On Error GoTo Error_RunFilter Dim FilterClause As String, D As Long Dim BoxSource As

  • How To filter a Combo-Box... 2012-02-25

    I'm trying to filter a Combo-Box to only show the values I want depending on the record I'm on. Ex. Get only those "contacts" (in the combo-box) from the Form "Company". (relationships already done "1-to-many"). I can't make that combo-box to show on

  • Using a combo box to filter records on an access form 2012-05-02

    I'm attempting to filter records on my form based on the drop down values of a combo box. However, I'm trying to filter the records of two different fields based on the value in a single combo box. Both fields (Site_A) and (Site_B) contain the same t

  • Filter combo box values based on another 2012-06-18

    How do I filter the values shown (listed) in a combo box on a form based on the selected value in another combo box in that same form? Example: ProductType (Pesticide, Fertilizer, ..) and ProductName (Prod1-Pesticide, Prod2-Pesticide, Prod3-Fertilize

  • Filter Subform Data using combo boxes 2012-07-04

    Here's what i have/need. Any help is greatly appreciated. 1 form (form_SearchProducts) containing: 3 combo boxes (cboCustomerName, cboProjectNumber, cboModel Number) 1 subform (subform_ShowProducts which is linked to table_Products) I want to be able

  • using combo boxes to filter data 2012-07-16

    I've created a database that allows you to search through the records and which displays more in-depth information of each record on the right hand side once you click on any item. I am however hoping to have one more function which is to choose a se

  • Filter a combo box on a subform 2013-01-14

    Help me!! I have a main form, " frmFundingDistribution ", with a combo box "cboProjectRef"; and a sub form "subfrmEventPayments " that has a combo box "cboEventDescID". I need the combo box on the subform to filter based upon combo box on the main fo

  • MySQL How to combine combo boxes to filter a table? 2013-01-30

    I need to know what would be the best way of going about having multiple multichoice combo boxes populated from tables like genres,years,etc... and when the user selects one or more of them it will filter the main table movies for example out? Also i

  • Filter with multiple Combo Boxes 2013-04-12

    an age old quetsion but ive nearly cracked it- just stuck on last part of my code. Im using a guide i found on the web by Tony Hine about filtering with multiple comboboxes. basically the combo's on the main form fire an activate event to requery the

  • Filter sub form with a combo box 2013-05-01

    I need some help with filtering. I have a form based on a table. On this form I have combo boxes. Depending on the selection information will be displayed in a subform. One of the combo boxes is getting it's record source from a lookup table which li

  • How to filter customer records with combo boxes in separate forms? 2013-09-05

    everyone, I am a new member just join dBforums. I am quite new to database environment so my questions may be a bit long please bear with me. I am trying to create a database using Microsoft Access 2007 for my company with respect to customer records

  • Oracle How to Filter the List in Combo Box in JDeveloper? 2013-09-19

    guys, I really need your help regarding this matter. In JDeveloper, I need to filter the list in combobox in order for us to query faster especially when the list is very long. For example in a 'Country' combo box, when you type 'p' in the field, the

  • Reports Filter by combo box 2014-08-25

    I have created reports which needs to be filter out based on user selected value from the combo box. Detail : I have form with option group and combo box... when user selects one of the option combo is visible which allows user to pick value and then

  • Using Combo box to filter options in 2nd Combo box 2015-01-28

    Using Combo box to filter options in 2nd Combo box Hi there folks! I have created a form for entering records. The form contains 2 Combo boxes and a text box. The First Combo box contains a list of "Project Titles" from a table. The user selects one

  • using combo box to filter subform text box 2015-02-28

    I have a table with about 8 fields. I would like to create a form in which the user could select an option in a combo box, and that option would bring up the data that goes with it from the table into a table in a subform. If I could filter the table

  • How can I filter using a combo box? 2015-03-05

    I have a form and want to filter out records using a combo box. I want to fitler by the user name "UserID". What would be the best way of doing this? Aboo

  • filter combo box 2015-03-09

    Howdy Fairly new at this so hope someone can help. Have looked around the forum but can't find a solution to my problem I have used the wizard to add a combo box (combo1) that goes to a particular product record that I select in the combo box. This i

  • filter records in combo box 2015-03-13

    I was trying to filter records from a combo box in a form, I received an error message said “Type Mismatch in Expression”. It means a join expression is attempting to join the two tables on fields of incompatible data types, according to Microsoft Ac

  • Filter subform data using combo box in main form 2015-04-18

    I have been staring at this for a couple hours. I am fairly new to Access, so bear with me. I have a form that I use to enter data into a table (Invoice Details) for tracking fleet vehicle maintenence. One of the form fields is a combo box which is c