Search results

Thank you so much for your reply. Absolutely is a typo, which I have since corrected. However, I believe I assigned a value here --> strProjectNumber = strFacilityCode & "-" & Record_Number.Value <-- in the "If" block immediately after the call to the MsgBox. It does the update but updates...

Humble assistance requested: below is sub that attempts to update the current record with a concatenated value. ALL records are being updated rather than the record specied in the WHERE clause. Person who designed this db used non-standard table names etc. so there are lots of spaces to contend...