Validate Phone Number based on other field

[gbeegle]

Struggling to validate a phone number field based upon another field (state). Instructions I am to follow are below. The phone number field includes the area code

For a State field value of VA, the first three digits of the Phone field value must equal 703 or 804. If the Phone field value is invalid, display an appropriate message, cancel the event, undo the change, and move the focus to the Phone field.

 

[ted.martin]

First, you need to create a table to LookUp the 3 digits.

Then using a text box for the selection of the state, use a combo box with its Row Source filtered to the table based on the value in the states text box.

 

[gbeegle]

Ted,

Thank you very much for your reply. I certainly understand the concept of your answer. However, when you say create a new table to lookup the 3 digits are you saying to create a new table with just state names and area codes?