Forms - Cbo Box with columns

[wprdk]

I'm working on setting up a database for equipment and parts. Equipment is listed in 1 table and Parts in another

In main form (equipment) am using a cbo box with 4 columns. I'm using the =[name].column() in control source of 3 fields and information is displaying and updating appropriately.

In second form (Parts - to become subform) am trying to use a cbo box with 2 columns. the cbo box works fine, but I can't get the other field to display. Using same =[name].column(1) in control source. After lots of playing, have gotten display if use =[name].column(1,1) to show column and row. Problem is it's working backwards. if change to =[name].column(50,1) display changes to new row. Every time change first number, display changes. It appears as if it working as .column(row, column) not the specified .column(column,row). Am not currenly using any after updates or codes.

Based on threads read her, have tried using similar code in after update to no effect.

Any Ideas whats going on or what the problem is????????????

 

[wprdk]

Found Part of the Answer

As I said originally, I have been playing with this for a couple of days...........................................

I just found part of the answer (but don't understand why).

The one that is working was referencing a non-indexed field.

The one that was not working was referencing an indexed field (no duplicates).

There is an indexed field (duplicates ok) in the working form. I changed the look up reference to the indexed field and it stopped working.

On the form that was not working, I changed to the non-indexed field, and the cbo started working properly.

Can anyone help me understand????????????????