By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,983 Members | 2,082 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,983 IT Pros & Developers. It's quick & easy.

Lookup Date in Another Table

P: n/a
fak
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?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Suspect the problem is with ?DLookup("ClosedDate","ClosedDates","ClosedDate
= " & #1/09/2003) is that the date in the table will have, but probably not
show some additional hours, minutes and seconds
Try DFirst("ClosedDate","ClosedDates","ClosedDate > " & #1/09/2003) and
check if the returned date is equal to your entry date. ( You may have to
use the DateDiff Function and check that the difference is < 1 day)

Phil
news:2f**************************@posting.google.c om...
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?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.