Populate List Box with Query

[brighteyes]

Hey guys. I need some help. I want to create a form with a list box populated with records from a query. I select "Create form in Design Mode," then I drag a listbox onto the form and choose the option "I want the list box to look up the values in a table or query." Then I select the query and select the fields I want to see, hit next and get the message "Data cannot be retrieved from the source you have selected. You must select a different table or query to continue in the wizard." Apparently this is a known issue with microsoft and they have released a fix for it, but that doesnt seem to do anything. My querys are fine, , my tables are fine, , my relationships are good....

So, how can I populate my list box from my query? Im sure there are other ways than using the wizards.

Thanks

 

[brighteyes]

Solved. Under listbox properties, type your query in "Row Source," and change column count to the number of columns