Filter based on two combo boxes.
I want to filter equipment issues in a multiple items form by using 2 combo boxes, and a button. Here is an example.
I want to search every issue with the Packer on Line 1. I choose line 1 from the first combo box, which then filters the second combo box. I then choose the packer. I now want to click the button and have it show only those records that pertain to the line 1 packer. Let me know if this doesn't make sense. I've tried searching the web, but I can't find anything that makes sense.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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 have my first combo box working and filtering the data, but I need two more combo boxes to filter the data even further.
Can I do this? I am a complete novice and don't know where to start on the second combo box
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
when I apply the filter to the form, the filter applies correctly. but as soon as I try to put those results into a report I get boxes asking me to enter in asset_typeID.
problem is that when I filter with combo boxes, it returns the name of the asset_type and not the asset_TypeID.
ex. for laptops the ID = 4
What I would like is to tell the query that if one of the combo boxes is empty, it should search the next combo box for the value. Is there a way to do this in the query or sql?
What is does:
When I use the other combo box after my uses my first one it just adds to the results that are already there.
I need for it to do:
As I use my combo boxes it filters out all my data based on the criteria I have selected.
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
P.S I donot know VB.
I have them labeled as filters but nonetheless users keep trying to input into them for some reason. How would I add a message box to it so that it states that 'this box is not for data entry etc'. Is it the on dirty event or something like that?