I'm making an accessed-based database-app.
I wanted to make an array from textboxes, where the index is not known in front.
I made an array with 5 textboxes, (would like to be able to do this using ReDim Preserve maybe?) but my biggest problem is that EndOfFile doesn't work in my Loop.
This code I'm using (the filter property was a desparate attempt, I know I can lose it):
Private Function Maak_txtBox()
Dim i As Integer
Set RecSet = New ADODB.Recordset
.ActiveConnection = con
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockReadOnly
.Open "SELECT * FROM taalvaardigheid tv" '****(Comment)'WHERE trainee_id =" & intZoek
.Filter = "trainee_id =" & intZoek
For i = 0 To .EOF
txtTaal(i).Visible = True
txtTaal(i).Text = .Fields("taal").Value
Thanks in advance