By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,341 Members | 1,681 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,341 IT Pros & Developers. It's quick & easy.

Multiple categories

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.