S
sureshsharda
Guest
I am using Recordset to update a field(not enabled in the form) in a table. Though Access allows me to update the table and results can be seen in the table I cannot see the results in the form immediately. When I exit the form and re enter the results of the update are visible. I am using the following code
Dim dbs As Database
Dim rst As Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("service chart", dbOpenDynaset)
With rst
.AddNew
!Caller_Id = max (max is a private varibale)
.Update
End With
Me.Refresh
Please Help
Thanks
sharda
Dim dbs As Database
Dim rst As Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("service chart", dbOpenDynaset)
With rst
.AddNew
!Caller_Id = max (max is a private varibale)
.Update
End With
Me.Refresh
Please Help
Thanks
sharda