SQL Recordset Specific Fields

[Metaphoric]

I have written an SQL for form load so when the form starts it looks through a stock database and displays a message box showing the name and component ID of any products that have less in stock than the minimum number allowed.

The problem is that when i use a message box i can get it to display the name of the components but not the components ID. I used a for loop after the SQL code

Count = Components_recordset.recordcount
For counter = 1 to Count
Msgbox(Components_Record(counter) & " is running low")
next

How do i get it to diplay a specific field from the recordset that i looked up?

Thanks in advance,
Metaphoric

[si_the_geek]

you can access fields by name, eg: Components_recordset("componentsID")

also, you are showing a message for each field, whereas you should be showing a message per record instead, eg:

Count = Components_recordset.recordcount
For counter = 1 to Count
  Msgbox  Components_recordset("componentsID") & " " & Components_recordset("component_Name")" is running low"
  Components_recordset.movenext
next counter

alternatively (essentially the same code, just looks different):

With Components_recordset
  Do While Not (.EOF)
    Msgbox  .Fields("componentsID") & " " & .Fields("component_Name")" is running low"
    .MoveNext
  Loop
End With