ok, so i have managed to create my form with several txt fields and cbo boxes
and cmd buttons. when you click 'OK' puts that information into various
cells in a s/s.

Q1
is it possible to use validation rules in the cmb boxes on the form??
example
first cbo list fruit, vegetable, drink
depending on which one you select here ie 'fruit' the second cbo shows a
list of fruit only, and so on for the next cbo. i have a total of 4 cbo
boxes to drop down to.

and if this is possible i am hoping the next wish list might be.

Q2
if the user was smart and new what they wanted in the 4th cbo and they went
to select that then the 1st, 2nd, 3rd cbo auto populates with the relevant
information.

any help on either of these questions would be great

cheers Pete