what it is, i have saved data on a previous form into the database as words, but then i convert the words into its own unique ID. thus i want to load the data in another form, but i want to load the name of the item, not the ID.
but the problem is, ive made a program to do computer builds. so when i store data they all need to be apart of the same "group" e.g.
build number component ID
any ideas? heres what i have on the form load.
Private Sub Form_Load() conConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ App.Path & "\" & "database97.mdb;Mode=Read|Write" conConnection.CursorLocation = adUseClient conConnection.Open With cmdCommand .ActiveConnection = conConnection .CommandText = "SELECT * FROM Builds ORDER BY buildnumber ASC;" .CommandType = adCmdText End With With rstRecordSet .CursorType = adOpenStatic .CursorLocation = adUseClient .LockType = adLockOptimistic .Open cmdCommand .MoveFirst End With component = rstRecordSet!buildnumber lstList.AddItem component If component = 1 Then lstList.AddItem "*" End If