Hi All
I am trying to execute the following SELECT statement on my form but getting error:
sql = "SELECT DoctorsID,AppointDate,AppointTime FROM qrySubformAppoints WHERE DoctorsID=" & Me.ID & _
"AND AppointDate=#" & Me.txtAppointDate & "#;"
I would be grateful if can help.
Many thanks
I am trying to execute the following SELECT statement on my form but getting error:
sql = "SELECT DoctorsID,AppointDate,AppointTime FROM qrySubformAppoints WHERE DoctorsID=" & Me.ID & _
"AND AppointDate=#" & Me.txtAppointDate & "#;"
I would be grateful if can help.
Many thanks