Cascading Combo Boxes; Filter by one or both

I have two combo boxes: Customer & Location

They are linked to each other when Customer is picked Location is updated to only the Location that customer was in.

Is it possible to filter by both to find records and also to filter by just Customer and filter by just Location. So if one is NULL it will ignore that combox box and if both are NULL it will ignore both.

I am having trouble with filtering by individual combo boxes.

I have the cascading combo boxes change with no problem

Sponsored Links:

Related Topics

Three cascading combo boxes to enter data to a subform
I have read many cascading threads and tutorials and videos on thesubject and still it does not work,
My scenario isthat I have a form named “frmMain” on it has three cascading combo boxes, the first named “cboStation”, the second “cboStaff” and the third is “cboPPE” and a sub form calledsubfrmMaint to enter the required data:
[CODE]

first I use the cboStation to filter the names for the cboStaff then thatis used to filter the chip number for the cboPPE, which is then used to filtera subform so I can enter details into the it, called subfrmMaint.

When ever I open the cboStaff I keep getting a form appearing with “Forms!frmMain!cboStation”requesting me to enter something so it can filter combo box but ends up blank.

In the row source field for cboStaff :


Using Cascading combobox to filter, sometimes...
I have a form that has two combo boxes in the header to filter the form.
The first is the Category combo which after selected, filters what is in the drop down of the second combo box.

The question is, is there a way to allow the second combo box to show everything available (un filtered) if the user does not select the category combo first


4 Tier Cascading Combo where last combo looks up a record
I have been at this for some time, searching for a way to put these cascading combo boxes into practice. I keep getting all kinds of problems. Can someone give me a detaileddescription as to how to put these cascading combo boxes into practice.

Note: I am using a GUID as a primary key

I have a form that has four combo boxes. What I wish to do is have my last combo box selection look up a record.

My form is named batch and pulls from 3 tables
My 1st combo box is named cboPartNumber
My 2nd, cboTraceNumber
My 3rd, cboPONumber
My 4th, cboInvoiceNumber

My first one is supposed to hold what where?
My second one is supposed to hold what where?
My third last one is supposed to hold what where?

I have been referred to several other links and none seem to work right.


How to get cascading combo boxes to work properly?
I am using MS Access 2007. I have a form that has two combo boxes, one for divisions, the other for groups. I am trying to create ‘cascading’ boxes that will allow a division to be selected and will populate the ‘group’ combo box with all the groups for that division.

I have read on the internet about cascading combo boxes and have created mine the way I have seen in some other examples. My problem is that the ‘group’ combo box is never populated.

I can independently run the select statement that is in the cboDivisions “AfterEvent” and it returns values, just doesn't’t work on the form.


cascading combo boxes stop working in DAP system
I have created three cascading combo boxes based on filtered queries(that restrict records displayed based on the record selected in the previous combo box). They are all working fine on the machine with MS Acess installed, but when I use the form via a switchboard interface on a different computer that does not have Acess installed, the second and third combo boxes come up blank. All the rest of the forms work perfectly. Any suggestions as to why this is happening


Cascading 3 Combo Boxes
I am trying to cascade three combo boxes (Area>Bone>FracDesc1) and I have three tables (tblArea, tblBone, tblFracDesc1) that I am working with. I am able to connect the first two combo boxes so that when I select a value in the Area combo box, it filters the choices for the Bone combo box.

However, when I select the value in the Bone combo box, I get a pop up saying "Enter Parameter Value." I cannot figure out how to get the Bone combo box to filter for the FracDesc1 combo box.


Report Using Cascading Combo Boxes
I have made a Cascading Combo Boxes form this form has 3 combo boxes its working perfectly. I have to select items in all 3 combo boxes to get a report.

what I want is, if I do not select (leave empty) any item in the third combo box it should give me the report for all the items in the third combo box "Me.SubDesCbo"


cascading combo box subform data filter
I have a form with three cascading combo boxes and data is entered via a subform, the third combo box will only ever have four entries in it max.
I can fill the subform in, them requery the form and select another item from the third combo or exit the form.
What I want to do is that every time I requery the form and go back to the third combo box, the item that I selected previously is removed from the combo box list, and so on till no more item are left. or the form is closed down.


Filtering a continuous form
I have a basic continuous form in Access 07. It has the following fields:
Serial #, Part #, Model #
I want to put combo boxes in the header to filter the form. I have a combo box for each field. I named them:
SerialSearch, PartSearch, ModelSearch

The combo boxes are based on tables to automatically update when a new serial, part, model # is added. So, I got this far, so now I have a continuous form with three combo boxes in the header. I can select a value from the combo boxes, but I have no idea how get these to filter the records. I would like to be able to enter values into multiple combo boxes and have it filter, or when the combo boxes are blank, I would like it to show all records.


Cascading 4 combo boxes
I have a form that uses two cascading combo boxes (cboCity and CboStreet) to filter records in a subform.
The code I use for that is:

Private Sub cboCity_AfterUpdate()
sfrmDonorInput.Form.Filter = "[City]= '" & cboCity & "'"
sfrmDonorInput.Form.FilterOn = True
Me.cboStreet = Null
Me.cboStreet.Requery End Sub Private Sub cboStreet_AfterUpdate()
If IsNull(cboStreet) = False Then
sfrmDonorInput.Form.Filter = "[City]= '" & cboCity & "'"
sfrmDonorInput.Form.Filter = "[Street]= '" & cboStreet & "'"
sfrmDonorInput.Form.FilterOn = True
End If End Sub

So far it works fine. Now I have a need to add 2 more combo boxes (cboCivilYear and cboLocalYear) that should filter the records further. For the life of me I can't figure it out.


Syntax Error - Missing operator in query expression
I have a split form which I am filtering based on selections from two cascading combo boxes. The filter works fine with the first combo. But when both the first and second filter is applied, I get a syntax error.

The piece of code that I am using in the after update event of the second combo is:

Me.Filter = "[Group Description] = " & Me.FGroup_cbx & " AND [Program]=" & Me.FProgram_cbx


Filtering a continuous form
Wow, I feel like I'm loosing my mind at the moment! I have a basic continuous form in Access 07. It has the following fields:
Serial #, Part #, Model #
I want to put combo boxes in the header to filter the form. I have a combo box for each field. I named them:
SerialSearch, PartSearch, ModelSearch
The combo boxes are based on tables to automatically update when a new serial, part, model # is added. So, I got this far, so now I have a continuous form with three combo boxes in the header.

I can select a value from the combo boxes, but I have no idea how get these to filter the records. I would like to be able to enter values into multiple combo boxes and have it filter, or when the combo boxes are blank, I would like it to show all records.


Requery: cascading combo boxes filtering the results for the second
I'm having some trouble, I have two cascading combo boxes, the first filtering the results for the second.
When I add new data to the subform or either table, the new categorized aren't added to the combo boxes. I have been working on a requery with the code

Option Compare Database
Private Sub Form_AfterUpdate()
Me.Parent!productgroup.Requery
Me.Parent!cboRowField.Requery
Me.Parent!cboColoumnField.Requery
End Sub


This is not working. So..is this the right code or am I even entering the data in the right area's. And The code above is for the subform, should it be somewhere else. My whole application is based off the 7th Example down on this page entitled "Cascading Combo Boxes Data Base


Multiple-condition 'cascading' combo boxes?
I'm not sure if this type of thing has been answered before, but I've looked at most of the available cascading sample boxes on Google, (In fact, I'm not even sure if this fits under the typical definition of a "cascading combo box". It was the best title I could come up with on the fly, though.)

So, I have four combo boxes -- denoted as Combo171, Combo173, Combo 175 and Combo177 -- in a form in a database. The first three combo boxes are separate entities from each other(independent events), and the fourth denotes "None" (namely, that the first three conditions aren't met).

Each combo box displays the same two conditions -- "Yes" (bound as "1" in the form and in the table) and "No" (bound as "0" in my form and table).*

I'm drawing a blank is the situation in which the first three combo boxes all report a "No", and Combo177 reports a "Yes". I originally tried to write anIf/Then statement in VBA with "And" operators, but it appears that this approach doesn't work.

The sub that I wrote in VBA to try to create a combo box value change based on multiple conditions was:


Cascading Combo Boxes
I was wandering if anyone could help me with Microsoft Access Cascading Combo Boxes? Basically I have Region, District and Ward for Tanzania. I want them to cascade to each other in the table (UJANA) so you can select a region and only be able to populate the district and wards that are in the selected region.
I have uploaded the database so you can take a look and see why it is not working


Trouble with cascading cbo
I'm trying to figure out how to create cascading combo boxes, I have a form- NewItemFormthat has multiple combo boxes. Simply what I want is when Type cbo is selected, that the corresponding item selections are in the Item cbo. The Types are Can, End,Bottle and their Items are in REF_Prices.


Cascading combo boxes - are they able to do this?
I would like to set up a form containing a combo box with a list of mechanisms of injury. Some mechanisms have sub groups that I would like to have visible by means of linking them with a cascading combo box. Is it possible to have only some records from Cbo 1 link to Cbo 2? The examples I have seen to date show cascading data for all records in the first combo ie the city/state or postcode/suburb examples where every record has a sub record.


goto a form from a subform when in error
I have a form with two cascading combo boxes and a subform with a txt box, after you enter data into the cascading combo boxes the focus goes to the txt box in the subform, the data that isentered into the subform comes from serial numbers from two sets of clothing only four numbers, if you enter a serial number that has already been entered I have vba code that will search atable and tells you of this, but if you have mistakenly entered all of the serial numbers there is not a way to exit the subform and reset it so you can go back to the main form cascadingcombo boxes and enter another filter option.


Cascading Combo Boxes
I have now managed to add the code for cascading combo boxes to my form, but cannot make a connection with the table so that, although the form shows the selections I make, the table is not updated to store the values. Any suggestions very welcome.


Cascading combo box losing data
The data in my cascading combo boxes disappears when I navigate to another record. The table is updated but the combo boxes in the form are blank.

In my main form FRMREQUESTFORSERVICE I have three combo boxes: cboContractID cboSite
cboBuilding

The tables I have used to set this up are:
TBLREQUESTFORSERVICE
tblcontract1name
tblcontract2site
tblcontract3building

When I select the Contract this filters the list of sites. When I select a site this filters the list of buildings. However when I move to another record and return the site and building disappear.

I have tried to attached a stripped down version of the database but can't get it small enough.