I am developing an application in VB6, MS Access 2003, where i get an error when updating the data. Explanation below:
1- Open the application - no problem
2- Hit the add button - no problem
3- Fill the boxes and then Hit the save button - no problem
4- Hit Update button - no problem
5- Fill any box to be updated and then Hit the save button - ERROR HERE....TYPE MISMATCH
But, if i close the application re-open it and then hit the Update button, no error occur when saving the data.
Hope some of you guys help me with this. My application is very similar to an example from the net (i mod it to fit my needs cuz i'm a noob for sure). After trying to debug my application i found that the example from the net have the same issue as mine, the code from the example is a lot smaller than mine so i think it will be easier to debug the original example. It is a flexgrid example and i'm using VB6 enterprise edition. If someone need the whole project just let me know to attach it here if is no problem with the forum rules.
I put a not in the code where the problem appears to be. it is in the:
Private Sub cmdSave_Click()