Automatically insert in an Access Form

"How do I get an access form to automaticall insert a County name when a town
is selected in the Town Name" box from a combo list

Peter

Where I come from, "Aberdeen" and "Portland" are town names that exists in
more than one County. Are you sure you want to do this?

--
Good luck

Jeff Boyce
Access MVP

Hi Jeff
Thanks for your thoughts. What I actually have is a list of Counties and a
list of County Codes which I want to automatically insert into an input form
when the county is selected. The County list is in a seperate table as are
the County codes. I thought a combo drop down list for the County selection
would be the answer with the code then appearing automatically in a seperate
field

Can you help

REgards

Peter

"Jeff Boyce" wrote:

Peter

Where I come from, "Aberdeen" and "Portland" are town names that exists in
more than one County. Are you sure you want to do this?

--
Good luck

Jeff Boyce
Access MVP

Peter

If I'm understanding what you are trying to do, there's a more common way to
handle it.

You can create a combo box on a form that uses a query against a table other
than that connected to the form. If the form's underlying table has a field
to hold the ID/primary key value of the second table, that's considered a
"foreign key", and you can bind the combo box to the foreign key field.

If you build your combo box's query to include the ID field, and a
CountyName (two fields), then set the width of the first column (ID column)
to 0 in the combo box's property list, the combo box will display the
CountyName, even though it stores the ID value.

Or have I misunderstood?

--
Good luck

Jeff Boyce
Access MVP