Continious Forms

[David W]

How do you validate textboxes in a continious form without checking the a
new record(next record) in the form.
I tried, but I failed, when I exit the form it looks at the new record in
the subform.

 

[Rick B]

Of course it looks at the new record. The other records are already in the
database. It is too late to validate them. You can only validate the
current record. Each record is validated as it is added to the database.

You'll have to explain better what you are trying to accomplish.

Rick B

 

[David W]

We I hope I dont confuse you here.
I do have validation in place but the problem is when I exit the form it
checks the new record, is there a way around that.

 

[John Nurick]

Hi David,

For individual textboxes, you can use their ValidationRule properties
and/or code in their BeforeUpdate event procedures. For the form as a
whole, use the form's BeforeUpdate procedure.

If the textboxes are bound to a field in the form's recordset, the
underlying table's field and table-level validation rules will also
apply.