Greetings,I am new to SQL and would really appreciate some help.I have a form named "Family Information". Underlying this form is a table Family Info Table. Among other fields, Family Info Table has four fields FamilyID#, Lastname, Firstname, DateUpdated. I want to update the "DateUpdated" field for the record that is currently displayed on the form.I think that I need to do this using DoCmd.RunSQL.I tried to do this by updating the DateUpdated field using the FamilyID# of the displayed record. When I was unable to do this, I decided to see if I could get DoCmd.RunSQL to do something very simple.Here is what I tried.'DoCmd.RunSQL "UPDATE [Family Info Table] SET Lastname = 'Adams' WHERE Firstname = 'Roy & Dora'"The above command worked perfectly and updated just one record. Yes!!!Now I tried the following command to update the displayed record but I got an error. I am quite sure that it has something to do with the single quote marks but I do not know how to make it work because inserting a single quote makes the following text appear like a comment.The following command does not work and I would really appreciate help for this novice.DoCmd.RunSQL "UPDATE [Family Info Table] SET Lastname = 'Adams' WHERE Firstname = " & Me.FirstName & "'"Thank you,Ken Hill