Just a thought, I'm not sure if this is possible and I've been trying to figure out how this could work. My idea is to select a given date from a comboBox, once selected the database will automatically give me a location where to attend.
ComboBox date (dates are from a separate sheet populated).
A text box will then show me the location (that has already been booked for that date), yet again populated from a list.
Date Selected: 10/09/2017
Location: Room 21
I'm not sure how this could work, any thoughts (I'm not after any scripting, just a concept how it could work)?