If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Double Booking
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 |
#3
|
|||
|
|||
Double Booking
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 |
Thread Tools | |
Display Modes | |
|
|