I'm getting there....any help is accepted
=================================================
Option Explicit
Dim fItemNumber(10) As Integer
Dim fItemName(10) As Integer
Dim fUnitPrice(10) As Single
Private Sub cmdChoose_Click()
Dim Customer As String
Dim i As Integer
Dim found As Integer
Dim itemNumber As Integer
i = 0
found = False
'fNumRecs = 1
Open "a:\list.txt" For Input As #1
While Not EOF(1)
i = i + 1
Input #1, fItemNumber(i), fItemName(i), fUnitPrice(i)
Close #1
Customer = InputBox("What's your name?")
Print
Print (Customer)
Print "=================================="
itemNumber = InputBox("What's the item number? (Choose 1-10 inclusive)")
While itemNumber -999
If itemNumber = fItemNumber(i) Then
found = True
Else
i = i + 1
End If
Wend
If found = True Then
Print fItemNumber(i), fItemName(i), fUnitPrice(i)
Else
Print "Item Not On Stock"
End If
Wend
End Sub
====================================
in my a:\list , i only have 10 records.
for eg.
1,"coke",1.00
2,"pepsi",1.00
3,"sprite",1.00
.
..
...
10,"dr.pepper",1,00
==============================
also,My while statement seems to be unending.
While itemNumber -999
If itemNumber = fItemNumber(i) Then
found = True
Else
i = i + 1
End If
wend
It prompts me subscript out of range.