ValidationRule bug?

  • Thread starter Thread starter =?windows-1250?Q?Vladim=EDr_Cvajniga?=
  • Start date Start date
?

=?windows-1250?Q?Vladim=EDr_Cvajniga?=

Question #1:
Due to internal rules I'm not allowed to set ValidationRule on database
level. On form level how do I tell Access not to leave a record if some
fields don't meet validation criteria? ValidationRule doesn't work as
expected and in some cases it is possible to leave a record even if
validation criteria don't match!!!

Question #2:
Is there any function in A2002 to check validation rules field by field,
record by record (on form's RecordsetClone level)? We had that function in
my beloved PC FAND...

TIA

Vlado
 
Vladimír Cvajniga said:
Question #1:
Due to internal rules I'm not allowed to set ValidationRule on
database level. On form level how do I tell Access not to leave a
record if some fields don't meet validation criteria? ValidationRule
doesn't work as expected and in some cases it is possible to leave a
record even if validation criteria don't match!!!

Question #2:
Is there any function in A2002 to check validation rules field by
field, record by record (on form's RecordsetClone level)? We had that
function in my beloved PC FAND...

TIA

Vlado
Click to expand...

Do all such testing in the BeforeUpdate event of the form and set the Cancel
argument of that event to True when anything fails your tests.
 
Back
Top