dblist

[olemiss]

Hi everyone,
I am having a problem resetting the listfield in the dblist after either adding a customer to the database or after deleting one. Sometimes it works sometimes it doesn't.

BTW i am using VB6sp3 Access2000 and using ADO2.1sp2

To reset the dblist this is what I am doing
I am opening the recordset, requerying it, then close it.
Here is the code.


With Dataenv.rscustomer
if .state = adstateopen then .close
.open
.requery
.close
end with

dblist.rowmember = ""
dblist.rowmember = "customer"
dblist.refill

Any help would be appreciated.

Thanks