Combo box change

[nawaray]

Hello,



I have a combo box with different values(named description, cmddesc). When selecting one of these values I want some other controls, other combo boxes to have predifened values based on this selection. the other combo box is named price cmdprice.
i have table 3 which has the descriptions, and table 4 which has the prices
Actually i dont know how to write the code for this,
any help please?

[RuralGuy]

Maybe these links will help:
http://datapigtechnologies.com/flash...combobox2.html
http://www.fontstuff.com/access/acctut10.htm

[ssanfu]

You set up a query for the row source for the combo box. Then in the other combo box, you set up a query for the row source and have the criteria look at the first combo box. In the click event of the first combo box, requery the other combo box.

The point I'm trying to make is that we cannot read your mind and cannot see your mdb. You have to provide details..... hopefully meaningful table,field, control and query names, not something like Table4 or Text6. Take the time to give proper names to objects, being aware of reserved words. For example "Name" or "Date" are bad choices because they are not very descriptive ("Name" of what, "Date" of what) and because "Date" is also a built-in Access function.

In six months or a year, if you have to modify the mdb, you will have a bad headache from banging your head against the table because you can't figure out what you were trying to do. Trust me: been there, done that, got the bumps on my head to prove it.

[nawaray]

thankx RuralGuy and ssanfu

ssanfu, can you give me an example on the coding,?
for table 3 i have these fields (id_desc and description)
for table 4 i have these fields (id_price and price )

my form has 2 combo boxes:
description(cmddesc) and price(cmdprice)

what i want is when the user clicks on the description automatically the price will appear for that description , i dont want the user to choose the price.
(for example if the users chooses the description school automatically the price $100 will appear)

thankx in advance

[ssanfu]

ssanfu, can you give me an example on the coding,?
for table 3 i have these fields (id_desc and description)
for table 4 i have these fields (id_price and price )

How are Table3 and Table 4 related??