Validation Rule

[chthomas]

I have an Area filter (combo box) on a form. The records in the form are displayed only after applying the filter. MY problem is after applying an area filter, if the user want to adds a new record, then Area Text Box on the form should begin with the same area code in the combo box. Is it possible or how to apply a validation rule?
Eg.
If the combo value selected = Area66 Then while saving a new record, it has to be checked whether the value of Area Text box in the form begins with 66. How it could be done through an input Mask or Validation rule?

Regards and Thanks

Charley

 

[Jimmy Turnip]

Charley,

You could try changing the Default Value of the Area field in your form to [NameOfAreaComboBox]. This should automatically insert the area code into new records.

Note that this would even work if you set the Visible property of you Area field to False, which would prevent the user from overtyping the area code.

Good luck!