ms-access listbox weirdness (memory issue?)

Question

i have a huge sql query that is attached to the rowsource of a listbox.

the SQL statement seen here:

http://stackoverflow.com/questions/1358642/ms-access-select-from-another-query

actually returns the correct information if that information is under 2 records.

however if it returns more than 2 records it still populates the listbox but it populates it with null values. when i right click on one of the values and press COPY, it gives me this message:

"there isnt enough memory to retrieve data for the list box"

Answer 1

But does the query work if it is run separately? And is the number of columns in the query the same number of columns as you've specified in the listbox Column Count property?

In your reply you state that you have to combine it? Why? Basic trouble shooting is to see if you can run the query separate from the lixtbox.