HTML Table : Expected end of statement error.

[jasdem]

strAppointment = strAppointment & "<tr><td">" & _
                                        Format(rcdAppointment![Appointment], "h:mm AM/PM") & "</td><td>" & _
                                        rcdAppointment![DBN] & "</td><td>" rcdAppointment![Address_1]", "rcdAppointment![Address_2] & "</td><td>" &_
                                        rcdAppointment![Room] & "</td><td>" rcdAppointment![FieldCaptain]"</td></tr>"

I keep getting an expected end of statement error with this code. I am fairly new and this and not sure how to debug. Any insight would be helpful.

[pbaldy]

You need to separate fixed text and formulas/recordset references with &

"fixed text" & Whatever & "more text"

you've missed some.

[Dal Jeanis]

Also make sure and have a space between the ampersand & and the underscore _ at the end of a line.

[pbaldy]

Ah, I didn't notice that the line continuation wasn't correct on the second line. Good catch.

[jasdem]

Thanks everyone. I was able to clean up code and get everything to run smoothly.

[pbaldy]

We were happy to help!