Filling in multiple records from one text field

[JuniorWoodchuck24]

I have a form that issues documents. I'm trying to get the form to add the RevNo to the field in the main table to show what Rev it's on. The main table has all the required information and it shows up filtered based on a project selected.

Form:
Issue document
When document is issued Rev "A"
Write this to every record that is in the project under it's Rev Field

Table:
After VBA code has been run show "A" in every column associated with that project.

I've tried using rs and db where I edit (rs.Edit), but I think I'm typing in the code wrong because nothing writes to the field.

 

[PNGBill]

Something like this

  sqlString = "UPDATE TblLetterSent SET TblLetterSent.LetterPrinted = 2 " & _
        "WHERE (((TblLetterSent.LID)=" & LDPK & ") AND ((TblLetterSent.LetterDate)=Date()) AND ((TblLetterSent.LetterPrinted)=1));"
        
    DoCmd.RunSQL sqlString    'Update TblLetterSent Letter Printed Flag

In the full code, a letter is printed and this code then updates a field in TblLetterSent to 2 where it was previously 1.
This can do multiply records provided the criteria matches.