Populating an array using a query

Question

Hello all,

I am trying to populate an array using info from a query. The query looks at a specific date, entered on a form by the user, then looks for the number of orders entered by each employee on that date. I want to display the results on the screen and also be able to print it if needed by the user. Usually there are between 2 and 4 order entry people. I understand some about arrays and how they work but I can't figure out how to populate them from a query. 

Or would I be better off using list/combo boxes?

Any help would be appreciated.

Answer 1

I don't understand why you need to use an array.

Simply create a form, combo box, listbox, ... and use your query as the RecordSource or RowSource (depending on what you choose to use).

Answer 2

Sorry just wanted to see if I could do it using an array. I am already working on the list/combo box approach.

Thanks for the reply will mark this one finished