KingHavocIV
Last Activity: Dec 5 '13, 10:12 PM
Joined: Dec 2 '13
Location:
-
Thank you Seth for the insight. That worked with my original code. I guess I need to be more careful with my comparison operators. Thanks for pointing that out. -
Thank you ADezii, That worked perfectly. I don't know why the <> didn't work, but I'm glad you found a way to make it work. Thanks again.Leave a comment:
-
Adding code to Access for Specific Area Codes for a State
Hi All,
Can you see anything wrong with the below code? I'm trying to make sure that if the State in the record is VA, that the area code is either 703 or 804. When I test, no matter what I change the first 3 integers of the phone number to, I get the error msg box. Even if it's 703 or 804, I still get the error box. Any help would be appreciated. Thanks.
...Code:Private Sub Form_BeforeUpdate(Cancel As Integer) 'VerifyLast edited by zmbd; Dec 2 '13, 05:45 PM. Reason: [Z{Please use the [CODE/] button to format posted code/html/sql/formated text - Please read the FAQ}]
No activity results to display
Leave a comment: