Display diferent column in combo box

[ChrisDo11]

i have a combo box in a subform which is used to select different records in the subform. when you select a different "section" from the combo box, the "cbocompany name" is updated to reflect the company responsible for that section. once that happens theres a contact field which queries all the contact people for that company.

everything works fine, except i also have command buttons to navigate through the different sections, when i use these command buttons instead of the combo box to jump to a different section the contacts don't re-query to match the new company name?

Any suggestions??

Also,
in the combo box that i use to select different sections, it selects the information in column 1, i would like it to display the info in column 2. i've seen something like =[combobox].[column](2) but it doesn't seem to work. is this because i'm in a subform??

 

[Schof]

You can just requery the comboboxes when the user clicks on the navigation buttons and as long as the company field is in the comboboxes recordsource then you should get the desired result.


Comboboxes have a Column Widths property to define which columns in the recordsource to display.

For example:

To only display the second of three columns you set the columns widths to 0;2;0.