| | |
|
|
|
Table: Conidtions Fields |
|---|
| message from nl on 2 Jun 2004 |
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:)
|
| Van T. Dinh replied to nl on 2 Jun 2004 |
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)
if
field
Adm=2,
|
|
Archived message: Table: Conidtions Fields (MS Access Error Message)
