execute sql with textbox for date (1 Viewer)

I've the following SQL and update.

sAppt = "UPDATE tblTAppt SET ApptStart=#txtApptStart#, ApptEnd=#txtApptEnd#, Completed=chkCompleted, " & _
" AppointedBy=txtApptedBy, RankCode=fraHSR, JobPosition=txtJobPosition, Dept=sDept, Company=sCompany, " & _
" Honorarium=sHon, Allowance=sAll, FCF_No=sFCF_No, Budget=iBudget, DaysNotAvailable=sDaysNotAvailable, Remark=sRemark " & _
" WHERE tblTAppt.TRef = iID and iTApptID = txtTApptID"

CurrentDb.Execute sAppt

It runs into run-time error "3075", Syntax error in date in query expression '#txtApptStart'.

It is weird that it's "#txtApptStart#" but came out as "#txtApptStart".

Note: txtApptStart is format as "Medium Date".

I would be appreciated if you have any suggestions on this problem

I would use a query instead of SQL, it gets the syntax correct...
select * from table where [dtefld] = forms!myForm!txtDate

or
for sql , you don't need date delimeters for an update, but the textbox must be outside the quotes
or
put delimeters INSIDE the quotes, but the textbox OUTSIDE,

sAppt = "UPDATE tblTAppt SET ApptStart=#" & txtApptStart & "#, …"

Thank you for SQL construct.

Is there any alternative to implement the SQL?

Best.

EVERY variable has to be outside of the quotes, not just the control references. Since all is in quotes, Access will see

...AppointedBy=txtApptedBy...
not
...AppointedBy= 1254...


which raises another point. Any text values (not numbers) have to be delimited also. So your sql may need to look more like
I'm showing another method of writing sql for vba. I don't like to use line continuation characters - just my preference I guess. However, I'm assuming there are no text values that need to be delimited. As for a better way, what you're doing is common; it just takes practice to get the concatenation correct. Suggest you debug.print sql before trying to execute. Then you can either just look at it in the immediate window, or copy/paste into a new query to test as well. I would get in the habit of switching to datasheet view rather than executing the test query because you may not want to accidentally run an update query that you're testing.