Display a Table Column in a List box 1

[hcisteve]

I am somewhat new to Access. Without having to create a Query I want to display a Table column in a list box. They only way I could get this to work was to create a query that extracted that column. I have to do this for several columns and don't want to have to create lots of queries just for this. It seems like there would be a simple way to do this, but I haven't figured it out.

 

[PHV]

Put the SELECT instruction in the RowSource property of the ListBox

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hcisteve]

Thanks for your help. I tried this but it didn't seem to work:

Select Title from Group

Am I missing something?

 

[hcisteve]

I figured it out. I needed to specify the Row/Source Type and then it worked! Thanks!