How to traverse a record in a row source property of a component

[syedshaffee]

Hey people,

 
How Can I Traverse Through a row source Property of a component
 

is their any way to do the same? if yes please help

[TheSmileyCoder]

You need to be more specific, which components are we talking about?

A combobox has .Recordset property, I suppose you could take a look at that.

[syedshaffee]

i have a dropdown list and i want to traverse through that is it possible

[TheSmileyCoder]

Probably, what are you looking for, what do you want to achieve?

Do you want to loop through all the records doing something, or looping through looking for something? I can't guess your requirements, and you are being extremely vague.

[TheSmileyCoder]

This code loops through a combobox (cmb_SelectSubSystem) on my form, printing the second column:

Private Sub btn_Traverse_Click()
   Dim rs As DAO.Recordset
   Set rs = Me.cmb_SelectSubSystem.Recordset
   Dim strCombined As String
   rs.MoveFirst
   Do While Not rs.EOF
      strCombined = strCombined & "," & rs.Fields(1)
      rs.MoveNext
   Loop
   Set rs = Nothing
   MsgBox strCombined
End Sub

I dont really know if this could have any direct effect on the form itself, and what is selected in the combobox, but I dont think so.