It looks like I may have missed an ampersand. Try using this line instead.

SQL = "INSERT INTO [Registration Table] (First, Last) VALUES ('" & FirstName & "', '" & LastName & "')"

Also make sure the field names you are inserting into are correct.