Forum Discussion
How do I refer to a table field name in vba code during update process?
Here is my code: Public Function fnGeneral Dim rs As DAO.Recordset Dim ss As String Dim aLetter(1 To 14) As String Dim lGrid As Long Dim iLetter As Long Dim sField As...
Thanks so much for the replies, George. I know you are correct! I understand, and will work on it that way!
All I needed was the correct way of referencing:
Also, wild card in sql statement was ok to use.
Thanks for everything, George!
sField = "A1"
With rs
.Edit
.Fields(sField) = "B"
.Update
End With
Also, wild card in sql statement was ok to use.
Thanks for everything, George!
sField = "A1"
With rs
.Edit
.Fields(sField) = "B"
.Update
End With
- Congratulations on solving the problem.
Continued success with the project.
