Validation Rules

[RichardY]

I want to setup a validation rule where the 'Return Date' must b
greater than or equal to the 'Lent-Out Date.' I know how to set this u
on a form but I can't set it up on the table b/c the validation rul
cannot refer to another field in the table.

To complicate matters, the table is a subform in a form where users d
most of their data entry. It is in the subform that users would ente
the 'Lent-Out Date' and 'Return Date'. How can I create a validatio
rule for the 'Return Date' in the subform

 

[Jeff Boyce]

Richard

A sub-form is a form -- you can add an event procedure in the [Return
Date]'s BeforeUpdate event that compares to the [Lent-Out Date] value.

 

[RichardY]

Jeff,

How do I add an event procedure to a subform? When I open the paren
form in Design View and view the subform's properties I can't figur
out where I would enter an event procedure. Does it make a differenc
that my subform points to a table and not to a form?

Thanks for your help.

Richar

 

[Marc]

Jeff,

How do I add an event procedure to a subform? When I open the parent
form in Design View and view the subform's properties I can't figure
out where I would enter an event procedure. Does it make a difference
that my subform points to a table and not to a form?

Thanks for your help.

Richard

Open the subform itself in the forms window. Then you will have all the
events.
Marc