Results 1 to 3 of 3
  1. #1
    JohnnyK15 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    2

    Autofill Duplicate Information

    I'm trying to figure out a way that the user can autofill information from a record which was previously entered. For example, they fill out all of the form's fields and then go to the next record and would like that information they just entered to auto populate in the current record. Is there a way which this can be done? I was thinking maybe a command button the user could click on? But I'm not sure of how the code would work.

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    From Access Help:

    Repeat the value from the previous record

    In a field in a record, you can insert the value that is in the same field in the previous record.

    1. Open a datasheet, or open a form in Form view.

    2. Click in the field in which you want to insert the value.

    3. Press CTRL+APOSTROPHE (').

    Cheers,

  3. #3
    JohnnyK15 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    2
    Works great...thank you very much!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Using an Update query to autofill boolean
    By Fuzzyjello in forum Queries
    Replies: 13
    Last Post: 06-09-2010, 10:27 AM
  2. Autofill form fields based on another field
    By ljs1277 in forum Access
    Replies: 3
    Last Post: 02-16-2010, 02:51 PM
  3. date calculation then autofill?
    By nktrygg in forum Access
    Replies: 6
    Last Post: 01-19-2010, 11:04 AM
  4. Autofill with data from another form
    By jacrum in forum Forms
    Replies: 2
    Last Post: 08-11-2009, 11:17 AM
  5. Autofill form fields
    By roboticsguy1988 in forum Forms
    Replies: 1
    Last Post: 08-10-2009, 08:56 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums