Please help; combo box selection 2 text fields

[campanellisj]

I have attached my working form in the DB please if you can help I would appreciate it.

I have a combo box (cboMtoe) pulling from a query (Qry_Mtoe1) that generates a large list of choices. I would like those choices to fill in the appropriate text boxes that I have set up on the form.
I need the boxes to update each time a new selection is made....

If you can list out the steps I would appreciate it as well or use the attached DB and send it back. I am sure this is quite simple but I have been racking my brain all day and seem to be missing something!

 

[John Big Booty]

I don't have Access '07 here, so am unable to open your DB.

However if what you are trying to do is populate a number of unbound text boxes dependant on the selection in your Combo. What you will need to do, is in each of your text boxes, put the following as it's Control Source;

=YourComboName.Column([B][COLOR="DarkOrchid"]X[/COLOR][/B])

Where X is the number of the column that holds the data you wish to display in that text box. Remember that the columns in a combo are Zero Indexed, this mean that they columns are numbered from zero up rather than one. In most cases the first column is usually the hidden and bound column in the combo. The data you wish to display in the text box must form part of the combo's Row Source, it need not necessarily need to be visible though.

 

[boblarson]

Download my sample here and see how it is done.

 

[campanellisj]

Thank you both I knew it was something simple but I couldn't get it lol

Just out of curiousity is there any way to not allow duplicates from being assigned? I will be assigning those positions to actual names but I don't want to people being assigned the same positon. so how would I not allow duplicates?
would it be best to choose one of those text fields not to allow dups? for instance the LN field never has duplicate number so I would consider that field.....just asking you have helped alot already