Open RecordSet...

[anbusds]

Hi All,
May i know How to open a Record Set For the combo-box?
My Original Code as follows

Dim conn As New ADODB.Connection
Dim objMyRecordset As New ADODB.Recordset

Dim strSQL As String

Set conn = New ADODB.Connection
conn.ConnectionString = "Provider = SQLOLEDB; Data Source=SDSACCOUNT; Initial Catalog= SSPLCO; user ID=sa; Password=sa;"
conn.Open
'Do your query

strSQL = "Select ITEMNO FROM ICITEM;"

Set objMyRecordset.ActiveConnection = conn
objMyRecordset.Open strSQL
Me.Combo4.RowSourceType = "Table/Query"


After i use this code nothing come out on my combo-box...

Thanks in advance!!!

 

[Galaxiom]

This was answered in your other thread.

http://www.access-programmers.co.uk/forums/showthread.php?t=276257

 

[anbusds]

Hello,
Yes But may i have any sample code for open record-set or any example?
Thanks in advance Experts!!!