Hi,
i have been trying to create a drop down box but i haven't been very successful.This is the error that i get :
ADODB.Recordset (0x800A0E7B)
Cannot change the ActiveConnection property of a Recordset object which has a Command object as its source.
Here is the code:
Dim Cn, DataConn, MyRs, CommandText Set DataConn = Server.CreateObject("ADODB.Connection") DataConn.Open Application("Connection3_ConnectionString") Set Cn = Server.CreateObject("ADODB.Command") Set MyRs = Server.CreateObject("ADODB.Recordset") Cn.ActiveConnection = DataConn Cn.CommandText="Select ContactType From ContactType" MyRs.Open Cn, DataConn, adOpenStatic
Topic Options
Post Options
Thanks(0)
