I have a combo box with different start and end times for a scheduling booking service for members to hire out the gym at 3 different locations...however I would like to create a prompt message box whenever the user tries to schedule a booking for a client and the time slots of the different venues have already been booked by someone else. So, the user doesn't book a client when the facility is already hired out by someone else. Can this be done using access 2007 on a form format using vba or macros? If so, how can this be done? I don't mind creating a simple feature using macros or if needs be ussing vba...I am still relatively new to vba especially complex coding...
Thanks for your solutions.