ComboBox reports wrong record

[GGG]

I've got a record box: (table name: recordbox)
Which consists of A,b,c,d,e (ignore the numbers on the far right, just
for reference purposes)

A b c d e
1. 374 ember olive 3.5 5
2. 374 embery black 3.8 5
3. 374 embery blue 3.27 8
4. 374 embery green 3.1 5.7
5. 377 imbibed green 2.8 5
6. 377 imbibed yellow 2.75 8
7. 377 biog emerald 2.33 9

It pulls its' datasource from an underlying table.

Initially, it had no primary key field as there can be multiple records
with the same number (a). I have tried this example setting unique
keys to no avail.

It shows up fine in the combobox. It's code is, "select a,b,c,d,e
from recordbox"

I select record 2.
When the combobox reports back to the onExit event, it pulls the data
corresponding to record #1.
Same would go if I selected record #6. It would report back record
#5. See where I'm going?

It's onExit action is:

Me.Description.Value = GSANbr.Column(1)
Me.Color.Value = GSANbr.Column(2)
Me.Size.Value = GSANbr.Column(3)

Me.GSANbr.Value = GSANbr.Column(0)
NSN.SetFocus

These are the ones they refer to in the select query.

The only option I can think of (since I tried the first already to no
luck), is to set an ID associated with each record. That would be
cumbersome to me, and would like to try and make this work the way I
have it set up now.

Let me know if this is possible

Thanks

 

[Lee Robinson]

I created a blank database and then a table as you described. When I set up
a form and combo box as you described, it always reported values from the
record I selected. I can't make it give me values from the previous record.
What happens if you select the first record?

Perhaps if you sent me an example. From what you show here, it looks like
it would work.

Lee Robinson