Combo Box

[dogbite via AccessMonster.com]

I have a bound Combo Box how do I get more than 1 column to populate from the
same table, tblSub table is the row sorce. It's bound to tblMain.

Using Access 2000

Thanks

 

[Guest]

Click the elipsis to the right of the rowsource property. This brings up a
query builder that allows you to select columns, set criteria, sort order,
etc. In the combobox, set the column count property to match the number of
columns returned by the row source. Use the combo's Column Widths property to
set the column widths. A width of 0 will make a column invisible.

Barry