Hi Jim,
First, I recommend you put City and State in separate fields. Someday you will
be glad you did that!!!
On your data entry form, put the following code in the AfterUpdate event of the
City field:
Me!City.Default = Me!City
In the AfterUpdate event of State field:
Me!State.Default = Me!State
In the AfterUpdate event of Zipcode field:
Me!ZipCode.Default = Me!Zipcode
Enter your data in groups where the City, State and Zipcodes are the same.
For each group, after you enter the first record, you will see the City, State
and Zipcode you entered become the default values. All you have to do then for
the rest of the records in the group is enter the First Name, Last Name, Phone
etc and City, State and Zipcode will be automatically entered in the record. If
they change, just type over what has changed and that then becomes the new
default.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
" Jim" <jf***@gvtc.cm> wrote in message
news:x7******************@eagle.america.net...
I am just starting to put together a simple First name, Last name, Address,
City/State, Zip, Phone, & etc. database and I have several thousand entries
to make, many of which will have the same City/State and Zip code. I am
running Access 2000 v 9.0 Is there not an "auto complete" function that will
assist in the repetitive entry of all these same field entries?