Refreshing a screen after deleting a record.

A

Angel b1

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!
 
A

Angel b1

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...
 
M

Marshall Barton

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing the screen after deleting a record 3
Deleting records from a subform 3
Word OLE to check spelling in text box 1
OLE Word spelling 0
Subforms won't refresh after new record 0
Prevent Full String Selection after Change Event on Control 1
#deleted message on record 3
Need to Refresh form From Button 2

Top