I want to make a reservation. I type in the date and then click an Ok button to select the reservation time from a list field. But I want the reservation time list box to display the available times to choose for that day (not times that are already reserved or booked).
The table is called Mare-Status, data control called datProcessStatus, reservation date field called ReservationDate, reservation time field called ReservationTime. The reservation times to select from the list box are (if no times where yet selected or no reservation took place for that day) 09:00, 10:00, 11:00, 12:00, 13:00, 14:00, 15:00, 16:00, 17:00, 18:00.