How do I create a messagebox prompt for scheduling a timetable booking?

[wedd]

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.

:friends:

[HiTechCoach]

See if this helps:

Clashing Events/Appointments (http://allenbrowne.com/appevent.html)

[wedd]

This is good stuff...thanks :-)

[HiTechCoach]

You're welcome!

Good luck with your project.