Declan Mullen wrote:
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
In my mind, this would require a small database with linked tables.
Matt
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
