SQL Recordset Specific Fields
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