Hi,
I have a table called "Creatures" with fields "Animal" and "Type". The
"Animal" field will have values like "Dog", "Cat", "Elephant". The
"Type" field will have values that depend upon the value of the "Animal"
field. Eg if "Animal" is "Dog", then "Type" can have values like
"Boxer", "Poodle", "Labrador". If "Animal" is "Elephant", then "Type"
can have values like "African", "Indian".
Within my form I would like the "Type" field's combo box drop down list
to include the relevant values based upon the "Animal" field's current
value. Ie when "Animal" contains "Dog" then the drop down list only
consists of "Boxer", "Poodle", "Labrador".
Is this possible ?
Maybe the "Type" field's combo box "List content" property can have SQL
with an embedded variable that corresponds to the value currently in the
record's "Animal" field ?
Any tips ?
Regards,
Declan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
