combobox problem

[indhu]

hi all

tablename-sequence
formname sequence
fieldname (sequence)

How to retrieve the value from sequence table to form 5 where i ve combobox (sequence). i want the vlue to come to this combo.

[hariharanmca]

hi all

tablename-sequence
formname sequence
fieldname (sequence)

How to retrieve the value from sequence table to form 5 where i ve combobox (sequence). i want the vlue to come to this combo.

Dim i As Integer
Dim strSql As String
Dim rs1 As ADODB.Recordset
Dim strSql as string
Set rs1 = New ADODB.Recordset
strSql = ""
strSql = "select fldSequence, fldSequenceId from tblSequence"
rs1.Open strSql, Conn, adOpenKeyset, adLockOptimistic
For i = 1 To rs1.RecordCount
cmbSequence.AddItem Trim(rs1.Fields("fldSequence"))
cmbSequence.ItemData(cmbSequence.NewIndex)=rst1.Fi elds("fldSequenceId")
rs1.MoveNext
Next i

Use this Code

[indhu]

Dim i As Integer
Dim strSql As String
Dim rs1 As ADODB.Recordset
Dim strSql as string
Set rs1 = New ADODB.Recordset
strSql = ""
strSql = "select fldSequence, fldSequenceId from tblSequence"
rs1.Open strSql, Conn, adOpenKeyset, adLockOptimistic
For i = 1 To rs1.RecordCount
cmbSequence.AddItem Trim(rs1.Fields("fldSequence"))
cmbSequence.ItemData(cmbSequence.NewIndex)=rst1.Fi elds("fldSequenceId")
rs1.MoveNext
Next i

Use this Code

No hari, its not working

[hariharanmca]

No hari, its not working

Where and how you are useing that combo box

[Killer42]

Where and how you are useing that combo box

Yes, we definitely need more detail. Is this standalone Visual Basic? If so, what version? Is it a VBA module in Access? Perhaps you are simply working on a Form in Access, with no VB involved?

Plus, more detailed info about the tables/fields involved would be useful. Try to describe the situation in as much detail as you can manage.