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?

You can use Chr(34) (") instead of (').
Regards,
Diego

You'll need to double any existing quotes, so a RELPACE() function is needed.

If you are using VBA, something like:

worked like a charm, perfect.