Double Booking

Hi

I am trying to avoid being able to do double bookings in a form. I have a
combo box holding 3 options eg AM PM All Day. Based on the date of the
booking if it is ALL Day then I would like the combo box to be blank if PM is
booked on a particular date then I would like only AM to be available. I
hope this makes sense and that someone can give me Basic! instruction on how
to do this.
--
Regards Clair

Hi Chester,

if you really want to avoid double bookins I thing creating an unique index
on the combination of fields that should remain unique is the easiest way.
--
Kind regards
Noëlla


"Chester1" wrote:

Hi

I am trying to avoid being able to do double bookings in a form. I have a
combo box holding 3 options eg AM PM All Day. Based on the date of the
booking if it is ALL Day then I would like the combo box to be blank if PM is
booked on a particular date then I would like only AM to be available. I
hope this makes sense and that someone can give me Basic! instruction on how
to do this.
--
Regards Clair

See whether what Allen Browne has at
http://www.allenbrowne.com/appevent.html helps.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Chester1" wrote in message
news
Hi

I am trying to avoid being able to do double bookings in a form. I have a
combo box holding 3 options eg AM PM All Day. Based on the date of the
booking if it is ALL Day then I would like the combo box to be blank if PM
is
booked on a particular date then I would like only AM to be available. I
hope this makes sense and that someone can give me Basic! instruction on
how
to do this.
--
Regards Clair