how to handle inserting a string with an apostrophe? i just realized this is actually a problem for me because some names have an apostrophe.
right now this is my value field in the insert:
'" & Me.txtlastname & "'
how to properly quote it to be able to insert a quotation or apostrophe properly?