ACCESS - Non Functioning List Box

[micereza]

Here's the run-down... I have two tables, TABLE1 and TABLE2. I have two fields name1 and name2 in TABLE2 that are list boxes drawing information from TABLE1.

The problem, the name2 field keeps drawing information from the column for the name1 field. I have changed the bound column setting to a bunch of different things but it keeps giving me the information for the name1 field.

Can someone explain why I am having this problem in simple ACCESS terms? I'm not yet VB savvvy ;p

 

[Garridon]

You need to look at the Row Source property. That's what contains the fields and code running the query. When you click on the property, a button with three dots appears to the right of the property. Click that to open a query window so you can edit what the list box shows. This is where you can change the sort order to ascending or descending also.

Linda Adams

http://www.hackman-adams.com

http://www.david-hedison.com