combo boxes in access

[rhintintin]

When you set a combo box in access you can set more than one item from another table to be in the drop down, but how to you get it so that these are actually displayed in the table, in other words, the all the items that are in the combo box i want displayed in the table.

 

[Psychpt]

1. to have information from more than one table show up in a combo box, all you need to do is create a union query as its rowsource.

2. if I understand you correctly, only ONE field in your table can be bound to the combo box.
If you want to create a table with all the values use a Make-Table Query.

HTH
PsychPt@Hotmail.com

 

[jfhewitt]

Create a combo or list box and base it on an external table. Decide which field in your table will be bound to the box. For the other fields you want displayed, put text boxes on your form with the following formula:
=[<comboBoxName>].[column](#)
The columns start with 0, and the # is the column number you want displayed.