Using Data Grid Controls

[Chip]

I have been asked to work on an existing ddatabse that uses grid controls. I
have never used the Data Grid Control. I was wondering if I should just use
subforms in datasheet view instead.
Having looked at the VBA, it appears the data grid gets populated from
several combo boxes on the form and then the grid data populates a recordset
(which is a permanent table.)
Any thoughts?

 

[Mark Andrews]

If there is no special logic or functionality the grid is giving you that
can't be done with a normal datasheet, then yes go the datasheet way and get
the third party activex out of the mix. If the existing grid is bound to a
table then for sure just use a datasheet. Usually you get activex controls
involved when it is a trickier situation and the simple datasheet will not
work as easily.

My two cents,
Mark
RPT Software
http://www.rptsoftware.com