[AccessD] ComboBox Rowsource With 2 Field PK

Michael R Mattys michael.mattys at adelphia.net
Tue Sep 23 20:23:32 CDT 2003


Hi Access-D,

I have a table which cannot be edited per client 
instruction. It is linked into the current database
as the customer table and has two text fields that
comprise the primary key (Division and CustomerNo)

A third field, CustomerName, is the one I would like
to show in my combobox on my form in order to
select a customer. I cannot, however, make one 
or the other the bound column as the customer name
just disappears.

I have tried Bound Column: 1,2 and 1;2.
Doesn't work.
Does anyone know what I must do?

Mike Mattys




More information about the AccessD mailing list