I Need your urgent support . Validation Rule and VBA Code

[Ossama22]

Hello ,

I Have a Tabel which there are alot of cells , for Example i have 2 cells which i wanna to make a validation rule between them : Account Number & Clearance Code

i wanna to create a rule if the clearance code = any value , when i try to write any account number it shows a msg that we cannot add account number because there's a value in clearance code . is that possible in Microsoft Access Table ?

Or if any one can give me VBA cod to do that in form view : when i try to write in account number cell while Clearance code is not null , it shows msg box , can any one help ! Urgently

Thx for your support​

​

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/microsoft-access/1069096-validation-rulein-tabel.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.