Combo Box

[rhernand]

I have a form based on a query. The query reads a four column table and sorts one column. I have a combo box based on the query with the sorted column as the row source. Also on the form are the other columns.

How can I get the other columns to display their data fields when I click on an entry in the combo box?

 

[Fizzio]

You cannot display this data physically in the combo. Create a number of unbound textboxes (as many as you need to display the other columns in the combo).
Set the controlsource to =Forms!NameofForm!NameofCombo.Column(x) where x is the number of the column you want to display. (column 1 in the combo is actually numbered 0 though)

 

[rhernand]

Combo

I was not trying to display the other columns in the combo box. I had already clicked and dragged the other columns from the Field List to the form. I go to the combo box and click any of the entities and the other textboxes do not display the corresponding data.

 

[dcx693]

When you say "corresponding" data, you mean data that is supposed to go with the selection you've made in the combo box.

Is there a reason you have a four column combo box? Are you using the other three columns of the box somewhere else.

Fizzio assumed (and I would make the same assumption) that you were trying to pull the data out of the other combo box columns into the other fields. Is this not the case?

If not, then what data are you trying to display in those fields?

 

[rhernand]

Oops

Sorry for the confusion. I have a four column query, one combo box displaying the contains of one sorted column of the table and three text boxes displaying the corresponding data for the item displayed on the combo box.

The data on the three text boxes does not change as I focus and clicked on the different items of the combo box.

 

[indesisiv]

Have you got it set to requery the form on the afterupdate of your combo box?

 

[rhernand]

No, where dio I do this?

 

[indesisiv]

sorry my mistake ... i have had a look and it does work just as fizzio says earlier.

here is an exaple.

 

[rhernand]

Worked great!!!!

Thanks