problems with bounding

[BubBob]

The problem is this: i have a combo box where i choose a name. In database these names have different category ids (not unique). when i choose a name it jumps to the record with same category id, but name first in alphabets. How could i prevent this.

Question 2. Is it possible to pass values of two fields from a combobox? For example could i use both catgory id and name in the above case?

cheers.

 

[llkhoutx]

You combobox is more than one column, your binding the combo box to the wrong column.

Multiple value can be passed via a multiple combo box.

On the combo box AfterUpdate select the column you want by

me!Selection=me!YourComboBox.column(i)

where i is the column you want.

Set columns width of those column you don't want/need to display to 0 in the combob box column width property.

 

[Rod Barr]

In dealing with your problem about not having unique id's, you might want to try using the hidden index of each row.
You will find these values using:
me!Selection=me!YourComboBox.column(0)

The first row will return 0, the second 1, etc