Table: Conidtions Fields

  • Thread starter Thread starter nl
  • Start date Start date
N

nl

In a table, how can I make a field accept/or not accept if
theres a condition.
Example: Field Adm=1, Field End=06/02/2004 (in this field
the data is accepted only if Field Adm=1) If Field Adm=2,
then it should not accept the record.

thank you:)
 
For this, you cannot use Field Validation. You need to
use the Table Validation.

Open your Table in DesignView. Open the Properties window
of the Table and you should see a row for the Table
Validation where you can enter your validation rule. You
should also enter some text in the Validation Text to
explain to the user why the Record is not valid.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top