M
mattyv
ACCESS 2007
ComboBoxA shows filtered results by what was chosen in ComboBoxB
Hello, My name is Matt. Could a vba/macro/access guru help me?
By the way, I LOVE OFFICE 07!!!!
I am trying to achieve the fallowing and have been up and down this forum
and the internet without finding a clear concise answer! Please help!
A form where I have 2 ComboBoxs.
When I select the first ComboBox the second ComboBox UPDATES to filter out
the rest..
ComboBoxA lists for instance HARDWARE, SOFTWARE, SERVICES
ComboBoxB lists related to A CABLES, FREEWARE, ONSITE SERVICE
When I select item from ComboBoxA
ComboBoxB's results SHOWS CABLES and filters out FREEWARE, ONSITE SERVICE
Here is a sample of the content of the table = CATEGORIES
hardwareID category subCategory type subType
----------------------------------------------------------------------------
1 HARDWARE CABLES USB 2.0
1 HARDWARE CABLES USB 1.0
----------------------------------------------
I HAVE 2 TABLES
----------------------------------------------
PRODUCTS | CATEGORIES
============================
hardwareID | hardwareTypeID
category | category
subCategory | subCategory
type | type
subType | subType
----------------------------------------------
ONE FORM
----------------------------------------------
HARDWARE
---------------------------------------------
2 ComboBoxs ON FORM = HARDWARE
---------------------------------------------
category
subcategory
This is what I have tried in ROW source
SELECT subCategory FROM CATEGORIES WHERE
subCategory=Forms!THARDWARE!category;
----------
HELP! Thank you
Matt Valencia
Tags: access 2007 combobox updates after choice, combobox update filter
ComboBoxA shows filtered results by what was chosen in ComboBoxB
Hello, My name is Matt. Could a vba/macro/access guru help me?
By the way, I LOVE OFFICE 07!!!!
I am trying to achieve the fallowing and have been up and down this forum
and the internet without finding a clear concise answer! Please help!
A form where I have 2 ComboBoxs.
When I select the first ComboBox the second ComboBox UPDATES to filter out
the rest..
ComboBoxA lists for instance HARDWARE, SOFTWARE, SERVICES
ComboBoxB lists related to A CABLES, FREEWARE, ONSITE SERVICE
When I select item from ComboBoxA
ComboBoxB's results SHOWS CABLES and filters out FREEWARE, ONSITE SERVICE
Here is a sample of the content of the table = CATEGORIES
hardwareID category subCategory type subType
----------------------------------------------------------------------------
1 HARDWARE CABLES USB 2.0
1 HARDWARE CABLES USB 1.0
----------------------------------------------
I HAVE 2 TABLES
----------------------------------------------
PRODUCTS | CATEGORIES
============================
hardwareID | hardwareTypeID
category | category
subCategory | subCategory
type | type
subType | subType
----------------------------------------------
ONE FORM
----------------------------------------------
HARDWARE
---------------------------------------------
2 ComboBoxs ON FORM = HARDWARE
---------------------------------------------
category
subcategory
This is what I have tried in ROW source
SELECT subCategory FROM CATEGORIES WHERE
subCategory=Forms!THARDWARE!category;
----------
HELP! Thank you
Matt Valencia
Tags: access 2007 combobox updates after choice, combobox update filter