unable to add new data.**RESOLVED**

[sparkash]

I have created a new table which has about 60 fields. However,when i try to add new data:

data1.recordset.addnew

and scroll the data control, absolutely nothing happens. the data isn't saved.

Is the problem caused by the number of fields i have.

i have checked the data control and the textboxes are pointing at the data control.

Please help..

[pAmol]

why dont you use data1.recordset.update method for saving the data (you can use this code at some button click & label it as save)

also , though this is not essential but try using adodc instead of datacontrol .

[sparkash]

I am a newbie to databases, so initially i would rather use the data control.

if i use data1.recordset.update i get the following error message:

'update or cancelupdate without addnew or edit'. what deos this mean?

please someone, point me in the right direction.

Thanks

[diban]

hi sparkash

Its understandable that being a newbie u want to try the conventional basic data control but its all the more a reason to begin with ado. Pamol is right- use adodc, its almost the same as data control, only better. I helped a newbie like you in his application. This uses adodc, why don't you download the program and experiment with it. Go on the title VB and Access by jalbes, you will find the uploaded file there.

Happy learning