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