must be easy

[EscapeUK]

i have a table that contains two fields partno and partdesc

in another table I have orderdetails which stores the partno

I would like a combo box that displays the part description is it possible to have a hidden column that contains the number. The get that number and search the order table

(I do not want to have to link the tables in anyway at the moment because of performance issues.)

 

[braindead2]

Yes
set combos row source to

select partno,partdesc from your tablename

set the combo boxes column count to 2
set the column widths to 0,"1.5"
keep the bound column to 1

now the box will show the description only. If you want to show the partno as well just change the 0 width to .5 or what ever.