Cascading Combo Boxes; Filter by one or both
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
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
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.
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:
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 :
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.
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.
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"
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.
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.
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