DATA VALIDATION RULE BASED VARIED ENTRIES IN ANOTHER FIELD

  • Thread starter Thread starter hikerbiker
  • Start date Start date
H

hikerbiker

I am trying to create a validation rule for a table that will limit entries
based on values entered in another field of the same table. For example: if
my material field says "plastics", then my color field should only allow
"blue" or "red". If it says "steel", then it should only allow "red" or
"green". It appears that I can only limit the values in the color field to
be anything that might be valid for all materials.
 
I don't think you'll be able to do that with a validation rule.

If you only have a few possible combinations it could be done
with some simple VBA code behind a form. If you have many possibilites
it may be better to create a lookup table related 1:m to the materials
table and use a combo box on a form to limit the choices based
on which material was entered.
 
Back
Top