Populate Form(grid) from array

[hunterjj]

I want to create a form that is a grid, select certain records from a database, create an array, and then populate the form(data and properties) based on the info in the array. Can I populate the array using varaible numbers that relate the my array values without having to specify each and every individual block of my form's grid by it's exact name?
Also, what kind of SELECT statement will allow me to read/loop thru my database until EOF?

 

[gusbrunston]

[tt]
Hi:

The only thing I think of while reading your question is that you might use a crosstab query. I'm not sure what you mean by a grid, but a crosstab will give you a display composed of rows and columns.

I hope this helps. [tt] Gus Brunston - Access2000(DAO)[/tt] Intermediate skills.