Validation Rule

[CTQE]

Hello All,

Here is a really simple question for someone who knows the answer, lol.

I want to enter a statement on my form that prevents the entry of specific text based on a previous entry.

For example:

One field named "Make" may have the entry "Toyota". If Toyota is typed in that field then the next field named "Model" must return an error message if someone types in Malibu.

Any suggestions?

Thanks in advance

 

[boblarson]

This is going to get too intense for you to do it this way. You should have combo boxes to select the make and then the cascading combo effect will be that the combo to select the model would only have the values applicable available to select from.

Search on cascading combos here, or check out my sample here:
http://downloads.btabdevelopment.com/Samples/combos/CascadingCombosSample.zip
and post back after you've tried to look at it.