Textbox Control Source IIF statement

[Mark_]

I've done a bit of tinkering, let me know if this works for your needs.

I've used a parent form for a continuous subform. I've put the Start and End dates back together in a query that is limited by the date used in the parent form. I've also done formatting in the On_paint rather than trying to use multiple lookups to figure out what should/shouldn't be shown.

If you'd rather use colour instead of the captions, It would be a fairly easy change. I've made a small function to return if a given hour is/isn't booked, so changing it to return red or blue shouldn't be difficult.

If your original date do you keep time separate from date when you store when a room is rented?

 

[eacollie]

Thank you. What version of Access are you using?
I see an "Fs_Display" but nothing shows up. Is this the form you mean? Maybe I don't the functionality in my 2007 Access(?)

 

[Mark_]

Open FP_Display, the Parent.

I had set it to be the default form for the application. I am using 2016.

 

[eacollie]

Thank you so much Mark. I truly appreciate your help. I'll have to look at this when I finish work and let you know how it works. Thanks again!