Updating tables

[Guest]

I have a table named STREET, when the user enters a street name into a form I
want it to automatically update the table STREET. I also want them to be
able to see a list of the street names already entered from the form view.
Thanks

 

[Allen Browne]

Use a combo box with the STREET table as its RowSource, so the user can
select a street from the list.

Set the combo's Limit To List property to Yes.
Use the Not In List event to add new streets to the STREET table.

There is an example of how to do that in article:
NotInList: Adding values to lookup tables
at:
http://members.iinet.net.au/~allenbrowne/ser-27.html

 

[Guest]

I would think a ComboBox would be ideal for entering the street name into the
form. If you want it to automatically enter a new street name into the
STREET table, then I would check out this link:
http://www.mvps.org/access/forms/frm0015.htm
This module works very well in adding just one field (street name) to an
adjoining table. You just have to make sure that if your primary key is not
the street name, then make the primary key field column width is 0" and then
the next field (street name) will be the field that is typed in and updated
if neccessary.

This will also let you see the list of streets already in there (with the
comboBox) but you could also create a report or a simple query to view the
other streets in the table if you want a better view of it.
HTH,
Dana S.