How do you put a validation rule for ID numbers in Access?

B

Bonza

Require to validate all Identity Nos of my clients when capturing data. When
you enter the invalid ID no, it must report error.I have the validation code
from Department of Home Affairs to identify false ID nos. How do I put this
code in the system and in what fields/tables/forms must I put it in order for
it to work properly.Must also be able to identify a duplication of ID Nos,
whether Member or Spouse and quote the member no where it exists. Please
help!!!
 
K

KARL DEWEY

in what fields/tables/forms must I put it in order for it to work properly.
Without knowing your table structure it is a little difficult to say where
to put it.

What does a valid ID look like? Do you have a complete list in advance?
How will you be using the ID's? Just to build a list of people?

A few more details please.
 
Top