Multiple categories

[Zurghew]

Hi all,

Please help me here. I need to have a form which will allow me to select a
particular type of service through a combo box and based on that value
choose another subcategory and based on that subcategory choose another
subcategory and then according to the item selected store the rates in the
table transaction.

Graphically, (pls excuse if not clear)

combo1--choose-->CategoryA...based on catA choose from combo2------>
SubCategoryA---based on SubCategoryA choose from combo3---->
SubSubCategoryA......based on this combination of all the three multile
categories fill up the rates field .

I have no idea how to acheive this any tips will be of great help.
--
Thanks n Regards,
Z

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tip:

Combo1_AfterUpdate event -> Combo2.Requery
Combo2_AfterUpdate event -> Combo3.Requery

Combo2.RowSource property:
SELECT * FROM table_name WHERE related_column = Form.Combo1

Combo3.RowSource property is similar; i.e., it uses Combo2's value in as
its filter criteria.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQa1GZ4echKqOuFEgEQLKDQCfXPv2i/s80L6PFPsw/wcd/o3ma0UAniDY
j+uEh2Fz7MNtndcBtCmv8o49
=sCI8
-----END PGP SIGNATURE-----
Zurghew wrote:

Hi all,

Please help me here. I need to have a form which will allow me to select a
particular type of service through a combo box and based on that value
choose another subcategory and based on that subcategory choose another
subcategory and then according to the item selected store the rates in the
table transaction.

Graphically, (pls excuse if not clear)

combo1--choose-->CategoryA...based on catA choose from combo2------>
SubCategoryA---based on SubCategoryA choose from combo3---->
SubSubCategoryA......based on this combination of all the three multile
categories fill up the rates field .

I have no idea how to acheive this any tips will be of great help.