Getting an ADO Recordset linked to AN Access97 control

  • Thread starter Thread starter Jeff Gyarmathy
  • Start date Start date
J

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.
 
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)
 
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.
 
Do you have any code or examples or an web site that might
have an example?

Thanks.
 
Back
Top