I have a custom contact form. One of the fields is "relationship" which has a drop-down list from which to choose. The list includes client, attorney, accountant, etc. (We did this instead of just categories because people were making too many mistakes typing in the categories box.) Another field in the form in "Client Number". Is there a way to make client number a required field IF relationship = client?

I am cross-posting this on the VBA forum.