I have a workorder entry form. There is a table that contains
workorder information and another table that contains work dates that
are closed (fully booked). When the workorder form is being filled
in, I need the workorder date field to check if it is a "closed" date
(one listed in the other table). I was trying to use an AfterUpdate
on the workorder date, but I am uncertain how to lookup that field in
the other table and not allow work to be entered. The fields are both
date fields. The lookup or closed date table contains only the date
field and nothing else. Any ideas?