Topics Search

Filter based on two combo boxes.

Filter based on two combo boxes.
Views: 9
I'm kind of a newb so please bear with me.

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.
Sponsored Links:

More topics

 

Filtering a continuous form

Preview
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.
 

Filtering a continuous form

Preview
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.
 

Filtering a Continuous Form

Preview
I have a basic continuous form in Access 07. It has the following fields:
Serial #, Part Number, 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. I have tried to put in code for the filter. It will filter perfectly in the ModelSearch combobox, but the others will not. Attached is my database. If someone could please take a look, it would be a great help. It will open to the form that needs
 

Combo boxes Access 2007

Preview
I am trying to use 3 combo boxes on a form to filter my data in the table on the subform.

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
 

Cascading Combo Boxes; Filter by one or both

Preview
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
 

Filter Query Error

Preview
I have made an form that has multiple combo boxes that filters out data from my query. the combo boxes filter correctly but one my Manufacture combo boxes can anybody please help me [LINK]
 

Filter By Form Report (combobox issue)

Preview
I am using this help page to create a report based of my filter by form.

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
 

Filter based on two combo boxes.

Preview
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.
 

Choose 1 value from multiple combo boxes

Preview
I have four combo boxes based on types of classes taught at my institution. On the side, I have a query that opens a report based on the value selected in the combo box. [Forms]![main menu]![RTLC]

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?
 

Search form combo box filter

Preview
I have an Search form with two combo boxes it works almost correctly. On update when I use the drop down menu it gives me my criteria.

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.