Must delimit date/times with octothorpe (#) if the field is date/time. You're passing it as a string, so we'd have to know what the field data type is in the table if this doesn't fix the error:
= #" & InRS!AppointmentTime & "#")
That error message is one of the better/clearer ones IMO - quite simply the data type you're trying to use is incorrect for the field.
Please post more than a couple of lines of code within code tags (use # button on posting toolbar) to retain indentation and make it easier to read.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.