VBA Coding in Access

In a form I would like to be able to enter a piece of code into the form that will give a message to the user if the same data is entered i.e. I have developed a system that books rooms, if the room is booked for the same time on the same day then a message will tell the user that the room is already booked.