combobox dependence of an other combobox

[miketamp]

hi
i have a table called "dieta" which has 3 fields the "food", the "express" and the "kcal".Aslo there is a form called "paragogi" which has 2 comboboxes the first one called "Ctl1" and the other one called "Ctl2"The "Ctl1"combobox is linked to the "food" field and takes the values from there.I want to do this:
When the "Ctl1"combobox takes the "one" value then the "Ctl2" combobox links to the "express" field and takes the values from there as a list and when the "Ctl1" takes the value "two" then the "Ctl2" links to the "Kcal" field and takes the values from there as a list.If the "Ctl1"values is anythink diferent than the values "one" and "two" then the "Ctl2" value must be null
I use access xp.please help me as soon as possible!!!!
thanks...

 

[PHV]

And what have you done so far ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[KenReay]

See the FAQ section of this forum under comboboxes, tehre is a FAQ on this subject

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[miketamp]

thanks... i finaly found the answer in my problem!!!