add a value to a colume

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

Guest

I'm responsible for updating an access data base which has several columns.
One of the column list locations where business is done. We have a new
location
and I need to add new location. how do I do that.
i.e.
column list location
eight street
twenty fourth street
eleventh street
now I need to
add fourthteen street
to the list of selectable locations.
Thanks for the help.
 
On Tue, 23 Nov 2004 07:25:01 -0800, a johnson <a
I'm responsible for updating an access data base which has several columns.
One of the column list locations where business is done. We have a new
location
and I need to add new location. how do I do that.
i.e.
column list location
eight street
twenty fourth street
eleventh street
now I need to
add fourthteen street
to the list of selectable locations.
Thanks for the help.
Click to expand...

If you're using the table datasheet for data entry, be aware that
doing so is NOT recommended. Datasheets are *very* limited. And it
appears that you're using a Lookup Field with a list of locations -
this is even *less* desirable, partly because (as you are finding)
it's hard to maintain.

To do it in your current structure, open the table in Design view;
select this field; and click the Lookup tab at the bottom of the
screen. You should get the option to change the List of Values so you
can add "fourteenth street".

However, I'd really recommend creating a table Locations with your
desired set of locations; and then creating a Form (using the AutoForm
button from table design, perhaps). You can then put a Combo Box on
the form to find the locations in the Locations table and store them
in your main table.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top