combo box headach

[mike7510uk]

i have 2 combo's on my form, i used the combo box properties to add the items
when i select from the first combo i want the items in combo 2 to change depending on what was selected form cbo1

any ideas????

[dragul]

could u provide more details on what it is u want done.

[dafunkymunky]

hi mike

the solution to yours is easy
since i dont have my pc here i dont exacty remmember what is a combobox whether it is a pulldown menu or a list menu

whatever it doesnt matter
here is the solution

use the onchange combobox property and detect the new item selected and after this clear the combobox2 and fill it with the new details i would rather suggest you to write a separate function to empty the combobox

i dont remember if there is a inbuilt function which will empty the box but still you an write one for yourself
this is how you empty the box

for i=1 to combo2.<thepropertywhich gives you the no of elements in the box>

combo2.removeitem(i)
next i

and it would be better if you could specify more about your necessities like phate said

and remember since it is the first time you are posting here please dont forget to tick the solved tag once you have got the solution and also we would like you to post your
script in the script archive(if you wish)

--DAFUNKYMUNKY

[mike7510uk]

When the "valuation" combo is selected i want the "age" combo box to display
ONLY the information required which corresponds to the relevant valuation.

e.g

valuation is Less than 18,750

age should only list Less than 5 with GEE and 5 or more than 5 with LEE

if valuation is any of the other 2 options then age must show Less than 5 and 5 or more than 5 (the same as above but without the GEE,LEE)