Help With Lists

[Guest]

I have a list box with names of cities. I also have a field on the same form
that requires the name of the city. I want to be able to click on the city
name from the list box and have it place the selected item in the "City"
field of the form. How can I do this? I am a beginner to Access and would
appreciate the easiest solution. So far I've built my database and forms
using the GUI interface of Access and would like to have assistance using the
same method, if possible.

Thank you.

 

[Rick B]

Seems kind of redundant to me. Why not just have one field where you
selelct the city?

 

[AlCamp]

The list control itself can store the city value. There's no need to
send it to another text control.

If you have a field in your table called [City], then set the
ControlSource of your ListBox to [City],and whatever is selected (like
Boston) will be the value stored in the table for that record. On the next
record you might have Chicago selected.. etc etc.

Also, if you have many cities listed, it might be best to use a ComboBox
instead of List.

hth
Al Camp