Using combo box to select proper value from lookup table.

[GaryAks]

Problem how to be able to access the lookup table ( via the Combo Box in primary table) and see the first field and the forth field, I must see field 1 in lookup field to be able to select the proper 4th field. I have set the "column widths" to 1",0", 0", 1" to be able to see the first and 4 fields in the lookup table. The "bound column" is set to 4, to select the 4th field to be pasted in the primary database. The problem, the first field is the one pasted from the lookup table to the primary table. Shouldn't the "bound column" control which field from the lookup table is inserted in the primary database using the "combo box"? Or am I missing somthing?

Gary

 

[TomCologne]

Gary,

Is there a primary key in your tblLookup?

You're not alone,

TomCologne

 

[TomCologne]

Actually, Rick's FAQ faq702-681 might help you.

TomCologne

 

[GaryAks]

Tim
Yes there is a primary key, I tried moving it to the field I was trying to target as the field passed to the list box, but still the first field and the lookkup database was the passed value. I am evaluating FAQ702-681.
Thanks for your time
GaryAksland