Help With Lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top