Results 1 to 4 of 4

Thread: How to Automatically access the fields of an Access 2007 forms

  1. #1
    Join Date
    Oct 2008
    Posts
    79

    How to Automatically access the fields of an Access 2007 forms

    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.

  2. #2
    Join Date
    Dec 2008
    Posts
    202

    Re: How to Automatically access the fields of an Access 2007 forms

    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.

  3. #3
    Join Date
    Jan 2009
    Posts
    143

    Re: How to Automatically access the fields of an Access 2007 forms

    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)
    ------------------------------------------------------------------

  4. #4
    Join Date
    Jan 2009
    Posts
    99

    Re: How to Automatically access the fields of an Access 2007 forms

    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.

Similar Threads

  1. Replies: 4
    Last Post: 09-05-2012, 09:21 PM
  2. Replies: 3
    Last Post: 11-12-2010, 11:45 PM
  3. Mouse wheel does not work properly in forms of Access 2007
    By mahaFEB in forum Windows Software
    Replies: 5
    Last Post: 30-11-2010, 11:21 PM
  4. How to add two fields in ms access?
    By lootera in forum Windows Software
    Replies: 3
    Last Post: 03-09-2009, 09:18 PM
  5. Access does not allow Primary key with two fields
    By Reckon in forum Networking & Security
    Replies: 2
    Last Post: 16-06-2009, 03:48 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,710,826,795.47781 seconds with 17 queries