Record Still Showing in Form Even After Deleted in Code

[kashi]

hello
i m working on my project,someone plz help
i delete record ,after deletion result is saved in database(access),but not in vb form ,when i click on next or previous buuton ,i still see that record in form,and this record remains in form until or unless i reopen the form.
i m using ADODB ,record set and sql query like

a="delete from addressbook" where name='"& txtname.text *"'
 conn.Execute(a)

[Seth Schrock]

Just put

Me.Requery

right after your

conn.Execute

It will go to the first record in recordset and the deleted record won't be there.

[NeoPa]

That code will need to be called from the form that needs to be requeried. This may, or may not, be the same place you are running the SQL code a from.

If it is not then you need :

Call {Some reference to the form}.Requery()

See Referring to Items on a Sub-Form for help with that.

[Seth Schrock]

I guess I did make an assumption there. Good catch NeoPa. One more thing to think about when answering questions.

[NeoPa]

Seth:
One more thing to think about when answering questions.

Less straightforward than one might imagine, certainly. You're certainly heading in the right direction though. Welcome on board :-)