Hey Guyz/Girlz!

There is a little kool situation...

Using ADOdc, I have text boxes binded on my database...

If I go manually (with the next button) to a customer file, I can change informations into the boxes and informations are saved into the table...

If I look for a file (ADOdc1.Recordsource = "Select * From Customer Where Number=" & custnumber% & "' ;" then ADOdc1.Refresh), I can change the infos in the boxes BUT..

When I use my refresh button wich contain :

ADOdc1.RecordSource = "Select * From customers Order By Number ASC ;"
ADOdc1.Refresh

Then informations I changed in the boxes are not saved !???

Is it the wy I use to refresh my ADOdc who cause that !?

Thanks!

Yannick Lepage
---
Sherbrooke, Quebec