Creating a dropdown which shows one value but stores another

[Alex]

Hi Everyone --

I have two tables, one has a list of Items and one a list of Bidders.
I'm creating a Form to allow the user to select the Bidder Name from a
dropdown list. I want the Bidder Name to appear in the dropdown but
the Bidder ID to be stored in the Items table. How can I do this?

I'm using MS Access 2003 but saving it in 2000 format.

Thanks --

Alex

 

[fredg]

Hi Everyone --

I have two tables, one has a list of Items and one a list of Bidders.
I'm creating a Form to allow the user to select the Bidder Name from a
dropdown list. I want the Bidder Name to appear in the dropdown but
the Bidder ID to be stored in the Items table. How can I do this?

I'm using MS Access 2003 but saving it in 2000 format.

Thanks --

Alex

Set the Combo box rowsource to a query that returns both the BidderID
and the BidderName, i.e.
Select tblBidders.BidderID, tblBidders.BidderName From tblBidders
Order By BidderName;

Then Set the Combo Column Count property to 2.
Set the Combo Bound Column to 1.
Set the Combo Widths property to
0";1"

Set the Combo Control source property to the appropriate field in the
Items table.

Make sure the datatype of the field in the Items table is the same
datatype as BidderID.

The combo box will display the BidderName, but the Items table will
store the BidderID.