Display results of one feild into another

[umpie]

I need some help. I'm relitively new to Access.

I am running access 2003.
I have created a form with a space with a drop down box which I select the name of a PARK. The space below it is entilted CITY. I would like the program to automatically display the City name based on the Park that I entered.

I have a tabel which the drop down box for the PARK feild is connected to. In the table there are two colums, One titled PARK and one titled CITY. The entire table is called LOCATION.

If you have any suggestions please help

Thanks

 

[Funger]

In the dropdown that you use to select PARK, add the city column. Then in the AfterUpdate event of that dropdown use the code:

cboCITY = cboPARK.column(2)

where cboCITY is the name of the CITY dropdown
cboPARK is the name of the PARK dropdown
and cboPARK has three columns. Access numbers the columns starting at 0, so if you only have the PARK and CITY columns it would be column 1 instead of column 2.

sorry if that is confusing. If it is, ask another question and I'll try to answer it.

-Funger