Experts, I have a report with a field that has a double click event. I have noticed that I get an error if within txtDeliverable there is an apostrophe.
"Pay each invoice within 15 days of Interconnecting Party's receipt thereof"
^^^^apostrophe causes error on double click below
I had to run an update query to remove the apostrophe. After I did the update then the double click event works.
How to fix this? Does the double click event need to be adjusted?
Private Sub txtDeliverable_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmCovenantHistory", , , "[Deliverable]= '" & Me!txtDeliverable & "'"