Hi

I have a Customers table in Access 2007 with name and address fields, which contains a Town combox box that looks up a value [Town] in a separate Town table.

I created a simple Customer Form in order to easily populate the Customer table.

My Town table contains three columns:

1.  CustomerID - autonumber
2.  Town - text
3.  County - text

The Town and County fields are all populated.

What I would like is that when a town is selected from the drop down combo 'Town' box, the corresponding County field autopopulates into a text box underneath.

I have managed to almost achieve this by having a County combo box and setting the properties Row Source to read:

SELECT [TownT].[ID], [TownT].[County] FROM TownT;

this automatically brings back the County field of the chosen Town field - but the box itself has a drop down arrow and it lists multiple counties [as there are many towns that have the same county].

I have set the Locked status to 'yes' stoping the user from selecting a different county - but this looks messy.

I just want a static text box showing the right county that the town belongs to.

I have looked all over the net and all I seem to find are solutions using VB codes - but I have no idea how VB works so wonder if there is another, more simple, solution.

Thanks

Paul

---

Reply from Richard Rost:

What you need is a little bit of programming: an AfterUpdate event. After you select the value for your town, the box can then set other values on your form. See this tutorial for help on AfterUpdate events.