Passing ID number instead of Description

[khinester]

Hello,
I have two tables, Address and Region

The Address table has a FK_RegionID.

Now how do I make the form for the Address, so that I
have a list box that lists the RegionDescription and NOT
the RegionID. BUT only store the RegionID in the Address
table?

Thanks

 

[Rick Brandt]

Hello,
I have two tables, Address and Region

The Address table has a FK_RegionID.

Now how do I make the form for the Address, so that I
have a list box that lists the RegionDescription and NOT
the RegionID. BUT only store the RegionID in the Address
table?

User a ComboBox with two columns using the fields from the Region table as the
RowSource. Make the ID column zero width and the bound column. The Combo will then
store the ID but display the Description. The wizard for the Combo can do all of
this for you.