Data from combo query not displayed
Folks,
I'm using Access 2010. My form has a field based upon bound combo box via query. When I execute the query I see the data I'm expecting. When I execute the combo box from the form the combo box shows the fields but only displays the first field from the query in the combo box, whereas I need to see all fields once I've selected the item from the combo box.
I'm using Access 2010. My form has a field based upon bound combo box via query. When I execute the query I see the data I'm expecting. When I execute the combo box from the form the combo box shows the fields but only displays the first field from the query in the combo box, whereas I need to see all fields once I've selected the item from the combo box.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
tsgiannis,
Please reread the OP's problem. He is already selecting multiple columns and can see them when searching the combo. The column widths only controls the columns that are shown when the list is "open". When the list is "closed" it shows only the first visible column.
Please reread the OP's problem. He is already selecting multiple columns and can see them when searching the combo. The column widths only controls the columns that are shown when the list is "open". When the list is "closed" it shows only the first visible column.
ASKER
thanks - I'll be back. This is NOT a difficult form I've just very rusty with Access
I missed that part ...
You can adjust the Width for each column from "column widths"