Error: no information enough to change or update the record. Why?

[Roselene]

Hi, everybody!

I'm working with a form which displays a Data Grid like this:
=============================================
Expected Calibration Date - Consummated Calibration Date
=============================================
02/15/00
=============================================

Then I click on a button called "Add consummated date"
This button sets my DataGrid Enable and AllowUpdate properties to yes and then I fill in the date
(by the way, can I set the focus to the 2nd column at the end of this button code? I'm doing that manually for the time being. I guess that isn't a command like MyDataGrid.Columns(1).SetFocus)
But, let's going on:

Data Grid
=============================================
Expected Calibration Date - Consummated Calibration Date
=============================================
02/15/00 02/15/00
=============================================

And then I click on a button called "save", which runs the command
MyADOData.Recordset.Update
p.s. MyADOData is my datagrid DataSource.

But it causes an error message:
-2147467259 There isn't information enough about the column key to update or change the record.
MyADOData has 3 fields:
EquipmentID, ExpectedDate and Consummated Date, and I'm sure that all these columns have a value in it, cause I can see them.

So, what can the "not enough information" message be talking about?

Any ideas or comments?
Thanks in advance, folks

Roselene

[DrewDog_21]

I had a similar problem recently and received the same message from the data grid. I solved the problem by including the primary key with the selected data. If your table doesn't have a primary key then add an AutoNumber field and make it the primary key, then include in with the selected fields. Set that columns' visible property to false so that the user will not see it.


------------------
Andrew Nerney
Hapless Programmer
[email protected]

[Roselene]

Andrew,

I've used your suggestion and now it's working beautifully.

Thanks very much for taking the time to help me with such an useful answer. :-)


See you,
Roselene