How to Automatically access the fields of an Access 2007 forms

[Corona]

I'm trying to figure out how to get Access 2007 to fill in one field based on what is put in another field that means it would be automatic that if it has been updated on one field of a sheet,then it should be updated on the other desired filed. I am trying to format a form in Access where users could check off a box and have the home address.

[pancham]

AutoFormats in Access 2007 let you do more than just apply an existing format, however; you can choose which elements of an AutoFormat to apply, create new AutoFormats to match the formatting of an existing form or report, or modify an existing AutoFormat.

1. Open the form or report you want to format in Design view.
2. Click the Arrange tab.
3. Click the AutoFormat group.
4. Click AutoFormat Wizard.
5. Click the AutoFormat you want to customize.
6. Click Customize.
7. Select the Create A New AutoFormat option and click OK.
8. Type the name of the new AutoFormat in the New Style Name dialog box.
9. Click OK to close the New Style Name dialog box.
10. Click OK to close both the Customize AutoFormat and AutoFormat dialog boxes.

[Timothi]

You may place any number of combo boxes on your form as per your requirement.
---------------------------------Employee Combo Box---------------------
Properties
Name: Combo1
Control: Employee
Row Source: SELECT * FROM ...................(Table name VBA)
Combo1_AfterUpdate()
Me.Combo2.Requery
(and the below you may use the function on which you want to update the field)
------------------------------------------------------------------

[Astro121]

you can apply one of the AutoFormats installed with Access, Access provides a convenient spreadsheet-style datasheet view for entering data into form, it isn?t always an appropriate tool for every data entry situation.You can change the appearance of individual elements in your Office Access 2007 objects, but an easier way to change the format of an entire form or report at once is to use an AutoFormat that is included with Access. If you?re working with users you don?t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience.