I am trying to get a code that determines if a
specific date is already reserved against a table
of reservations.
I have queried the table to focus in on current
and upcoming reservations. Then I have a code
written in the AfterUpdate area of the StartDate
to compare the propertyID on the form with that
in the query. That’s fine.
But I cannot get it to then compare the StartDate
to see if it falls between the other Start & End
dates of the reservations for that PropertyID.
Example:
PropertyID 1 Has a reservation between 6/11/02
and 6/26/02
And has another between 7/4/02 and 7/15/02
Now I need the next reservation which starts on
6/25/02 for that property to tell me if that
is possible. Which obviously its not if you look
at the data. But I need the code to determine
this without looking at a table and MsgBox the
user that its already reserved.
For some reason it is not understanding the fact
that the new start date is between some other
start and end date.
I am probably seeing the forest and not the trees,
or vice versa here. Maybe someone can point out
a tree or two to me.
Thanks
K Darr