Additional Information
First of all, thanks to all you for look at this.
Here are the step I am doing on the desktop.
1. Fire the app up, click application, click customer menu.
2. click any customer.
3. add or change the data in the contact field on the first tab.
4. click the x, to exit the screen. msgbox will ask to save data. click yes.
5. at the customer list screen select another customer and do steps 2, 3 & 4 again.
6. exit the application and then go back in and look at the customer that you changed. Some of the time the first customer that you changed or add data too in the contact field will have been saved and sometimes not. But the data that you add to the second is not there.
7. You should note that sometimes when you go back and click one of the customers that you changed it will show that the data is still there, yet when you exit the program and come back in and look at the same customer the data will be missing.
8. One addtional item as noted in the orginal post. You can't click the same customer again after you save it. The click event will not fire. You have to select another customer and then go back and select that customer to view the data.
I placed a msgbox to look at the update text below the text vaiable to display it.
I have tried the following code to save the customer data-
text = "update Customer set ccontact = '" &TextBoxc8.Text&"' where (ccode = '"&custsel& "')"
text = "update Customer set ccontact = '" &TextBoxc8.Text&"' where (ROWID = "&recnum& ")"
text = "update Customer set ccontact = '" &TextBoxc8.Text&"' where (ROWID = '"&recnum& "')"
text = "update Customer set ccontact = '" &TextBoxc8.Text&"' where ROWID = '"&recnum& "'"
text = "update Customer set ccontact = '" &TextBoxc8.Text&"' where ROWID = "&recnum
I have checked the net framework version I have installed and it show that version 1.1, 1.1 hot fix and version 2 sp 1, installed.
BTW running xp pro. sp2