G
Gary Beale via AccessMonster.com
I have a continuous form which is the result of a query, giving a list of
results between two dates. This works fine.
What I want to do is add (or change) data to one of the fields in the list.
e.g. the user will enter a value in an unbound textbox, click the button
and this will change the field in each record.
I have written code which works really well, but for only five records!!
Any more than that and it doesn't throw an error but doesn't do anything
either. Code is as follows:
RunCommand acCmdSaveRecord
sqlstmt = _
"select BinLoc from qrySpvs where ([JobNo] = " & Me.JobNo & ")"
rst.Open sqlstmt, CurrentProject.Connection, adOpenKeyset, _
adLockOptimistic, adCmdText
Do Until rst.EOF
rst![BinLoc] = Text66
rst.Update
rst.MoveNext
Loop
rst.Close
Set rst = Nothing
I'd be grateful for any help.
results between two dates. This works fine.
What I want to do is add (or change) data to one of the fields in the list.
e.g. the user will enter a value in an unbound textbox, click the button
and this will change the field in each record.
I have written code which works really well, but for only five records!!
Any more than that and it doesn't throw an error but doesn't do anything
either. Code is as follows:
RunCommand acCmdSaveRecord
sqlstmt = _
"select BinLoc from qrySpvs where ([JobNo] = " & Me.JobNo & ")"
rst.Open sqlstmt, CurrentProject.Connection, adOpenKeyset, _
adLockOptimistic, adCmdText
Do Until rst.EOF
rst![BinLoc] = Text66
rst.Update
rst.MoveNext
Loop
rst.Close
Set rst = Nothing
I'd be grateful for any help.