Getting an ADO Recordset linked to AN Access97 control

[Jeff Gyarmathy]

I am trying to get an ADO recordset that I get from a SQL
Server database. To populate a combo box or list box in
Access97. Every time that I try to set the recordset = to
the Row Source I get a type mistach.

Please help.

Thanks in advance.

 

[Van T. Dinh]

I don't think you can use a ADO Recordset as the RowSource for Combo-ListBox
in A97.

A possible work-around is to create a ValueList from the data in the
Recordset and then use the ValueList as the RowSource.

HTH
Van T. Dinh
MVP (Access)

 

[Douglas J. Steele]

Van is correct. For that matter, you can't bind a DAO Recordset to combo
boxes or list boxes in Access 97: they don't have a Recordset property. That
wasn't introduced until Access 2000.

 

[Jeff Gyarmathy]

Do you have any code or examples or an web site that might
have an example?

Thanks.