Conditional formatting forms

[Guest]

I'm making a schedule blocked in 15 min increments. I have put conditional
formatting in to change the field different colors depending on what is
entered. Is there a way to automatically update the next group of 15 min
increments for items that take a longer period of time? If an item is entered
to start at 8:15 but will not be completed 9:00 I'd like to find a way to
have it blocked off instead of clicking in each field.

 

[Guest]

Just off the top of my head, assuming that the input is a text field for both
start and finish time of the appointment, why not something like;

If Me.Endtime - Me.Starttime > 15minutes then
Docmd.RunSQL "UPDATE tblappointment SET timeslot = taken WHERE
(((tblappointment.id)=(tblappointment.id + 1)));"
End if

Its rough, but it might get the brain ticking in the right direction.

Hope it helps,
Regards,
Nick.