A simple form for data entry, please help me

[sondo]

I creat a simple Table (Name CustD) and A From (Name All) for data entry about Customer Details where the raw data as printed copy.

The table and the form contained 7 fileds as below

1. Zone Code
2. Zone Name
3. DISRRIBUTOR Code
4. DISRRIBUTOR Name



5. Route Code
6. Route Name
5. Outlet Code
6. Outlet Name
7. Phone Number

Now I want to create the Form (Name All) user friendly for data entry operator. So that I want to

** field 1-4 will automatic fillup from previous record. Because most of the time those field are unchanged in raw data.
** Field 6 will automatic fillup after insert Route Code in field 5
** After entry data in field 7 and Press Save Button, Keyboard Courser should start from field 5. Because most of the time during entry period field 1-4 unchanged.

Please please help me. I'm new in MS Access.
It's very difficult for me but easy for you.

Thanks

[June7]

Easiest thing is to set DefaultValue property with the most common value for those fields. Pulling from the 'last' record will require VBA code.

Should not save OutletName, only OutletCode. Have another table for information about the outlets.

Same for DistributorName, save only DistributerCode.

You need a better understanding of relational database design. Review http://www.rogersaccesslibrary.com/