Datagrid Data Entry

[dvannoy]

Question regarding data entry using a datagrid.

say I have 50 rows returned in a recordset. what I want to do is enter data in the first column of the grid and then if all 49 records are the same entry as the first column hit a button that would duplicate the remaining 49 records for that column. so my row could have 5 or columns but in most cases the data is the same for the entire recordset.

hopefully I'm making sense.

I don't think the datagrid has an EOF function. I'm kind of stuck and any help would be apprecitaed.

Thanks

 

[tedsmith]

You manipulate the underlying data or recordsource to change the values in any cell, not the grid itself.
The EOF, MoveNext etc. are all available.
The data grid is merely showing what is in the recordset.

You can lock the datagrid.recordsource to a separate recordset in code or manipulate a ADODC control's recordset, I prefer the former.