-
I have an ADO control on my form bound to a field that allows 9 characters. After a user enters data in the box, I run the following code
Form.ADODC1.Recordset.update
Even though the user entered 10 digits, the update seemed to work. However, when I try and move to the next record, I get an error (Operation failed). It seems useless to run the .update if it is not really updating the record??????
If I place the following code in the same box
Form.ADODC1.Recordset.update
Form.ADODC1.Recordset.movenext
Then it errors.
I can issue a movenext and then a moveprevious but I was wondering if there is a better way??????
-
the ADO data control still has its quirks....what happens when you only put 9 characters into that field?
-
If I put 9 characters it seems to update it. I am having similiar problems with other issue related to this same issue. If I use the MoveNext and then MovePrevious, it works but I don't like the way it looks to the user.
-
would you be from donegal steve thomas??????????????????????
-
-
I suppose just put the maxlength of the textbox to 9, but that doesn't solve the ADO problem for you....sorry
