Active X and Data Grid
Thank you.
"onedaywhen" wrote in message
om...
"Richard Mogy" wrote ...
I am trying to access a SQL database and get a list for the user to
select
from to be used in additional queries.
I have created an ActiveX Data Object and a Data Grid Object, and I am
trying to figure out how to link the two.
In visual basic, in the properties, there is a line called datasource
that
links the two that isn't present in VBA.
Any help would be appreciated.
I assume you mean MSDATAGRD.OCX. I use it in an Excel project, but I'm
using a recordset rather than a data control. The Datasource property
is available at run-time e.g.
Set DataGrid1.DataSource = rs
--
|