I want to use a While Not EOF() to read some data.

I'm not sure what goes in the (). It seems to want an integer, but where is the integer coming from?

I really don't want ot use a a Do Loop.

What object are you trying to use to read the data? You should use a DataReader for read only data operations. This uses a different set of methods for iterating thru the results.

Depending on what you want to do with the obtained data, you might be able to just directly databind the result set object (DataReader or other) to a control (like a data grid) that will handle the looping for you.

I want to read a table in access and populated text boxes on a form with the matches.

If you are using a DataTable object, you can do:

For Each objRow As DataRow In objTable.Rows
    'Loops through each row
Next

Brian