Refreshing a screen after deleting a record.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im trying to refresh the screen after deleting a record.
This is what is under my delete button.
sql = "DELETE * FROM tbl_memberOverrides "
sql = sql & "WHERE tbl_memberOverrides.MemberID = """ & txtMemberID.Value &
""""
dbs.Execute sql
'Me.Refresh

The refresh is not working. Im getting #delete in the text boxes.
The source = table, the type is a dynaset. Help!
 
Angel b1 said:
Im trying to refresh the screen after deleting a record.
This is what is under my delete button.
sql = "DELETE * FROM tbl_memberOverrides "
sql = sql & "WHERE tbl_memberOverrides.MemberID = """ & txtMemberID.Value &
""""
dbs.Execute sql
Me.Refresh

The refresh is not working. Im getting #delete in the text boxes.
The source = table, the type is a dynaset. Help!
Click to expand...
 
Angel said:
Im trying to refresh the screen after deleting a record.
This is what is under my delete button.
sql = "DELETE * FROM tbl_memberOverrides "
sql = sql & "WHERE tbl_memberOverrides.MemberID = """ & txtMemberID.Value &
""""
dbs.Execute sql
'Me.Refresh

The refresh is not working. Im getting #delete in the text boxes.
The source = table, the type is a dynaset. Help!
Click to expand...


Try using Me.Requery instead.
 
Back
Top