[AccessD] ComboBox Rowsource With 2 Field PK

Michael

...use a query as your source ...concatenate the two fields in a query calc
field and use that to select records ...HTH :)

William Hindman
So, then, to every man his chance -- to every man, regardless of his birth,
his shining golden opportunity -- to every man his right to live, to work,
to be himself, to become whatever his manhood and his vision can combine to
make him -- this, seeker, is the promise of America.
-- Thomas Wolfe



----- Original Message ----- 
From: "Michael R Mattys" <michael.mattys at adelphia.net>
To: "AccessD" <AccessD at databaseadvisors.com>
Sent: Tuesday, September 23, 2003 9:23 PM
Subject: [AccessD] ComboBox Rowsource With 2 Field PK


> 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
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>