I'm getting a '3061: Too few parameters error. Expected 1;
...and am just stuck;
would someone have a moment to look over my shoulder (PLZ)
with thnx in advance,
m.
Code:' assign value to any existing records Dim vTableName As String Dim vFieldName As String vTableName = "tbeFixtureTypeDetails" vFieldName = "FixtComplete" 'dbInteger Set gsDbs = CurrentDb gsSQL = "UPDATE " & vTableName & " " _ & "SET " & vFieldName & " = 0 " _ & "WHERE " & vFieldName & " IS NULL;" gsDbs.Execute (gsSQL), dbFailOnError