Combo box selection is returning data from the wrong row

[Glenn_Suggs]

Hi all. I'm having trouble with something that usually seems quite simple. I have four columns in a combox box and the record source is a table with many records. One of the fields is Location and that is what the user is selecting on. However, when the Location, e.g. "10" shows up on four separate rows in the combo box, the data (which I'm loading into text boxes) always comes from the first of the four rows. In other words, from the row with the first Location "10", even though the user selected the third Location "10". I'm getting from the Help screens that there's a way to iterate through the rows to find the correct one, but when I try it, the code becomes convoluted looking. Is there a straight-forward way to get the right data? Here's a more detailed example of what I'm talking about:



Location Customer Region Unique Key
10 Joe 1 12345
10 Al 2 23456
10 Jack 3 808070
10 Murphy 4 123050

I couldn't get the data here to line up under the headings, but you get the idea.
When the user selects the third "Location 10", the data going to the text boxes returns the data from the first row. In other words:
Me.txtUKey = Me.cboUKey.Column(3) returns "12345" instead of "808070" as it should. Any help would be greatly appreciated and thanks in advance.
Glenn

[amrut]

Have you tried setting the width of all four columns to more than zero so that you can easily find what is going wrong ? What code you are talking about ? A textbox on a form with controlsource set to =cboUKey.Column(3) should show the Unique Key.

[Glenn_Suggs]

It looks like the problem came from a different part of the app where I was trying to get the name of the Region based on the Location alone. When i went back and removed that code and used something more suitable, it seems to have straightened itself out. Thanks for your input. Glenn

Have you tried setting the width of all four columns to more than zero so that you can easily find what is going wrong ? What code you are talking about ? A textbox on a form with controlsource set to =cboUKey.Column(3) should show the Unique Key.