Results 1 to 3 of 3
  1. #1
    jlgray0127 is offline Competent Performer
    Windows 2K Access 2000
    Join Date
    Oct 2011
    Location
    Central Illinois
    Posts
    187

    Forms

    I have a default value set for a field in a form, but as I am keying, if I delete the value, without typing in the field, and move to the next field, I need the previous field value to copy and input into the field I deleted the default value in. This is within the same record.



    So...
    Field A1 has a default value of "empty". I tab or click on it, and type in a part number. A2, (same default value) has the same part as A1. I just want to delete the default value and when I move from the text box, I want it to copy A1, and past into A2, the part number. There are 200 text boxes like this on the same record.
    Is there an easy way to do this?

    Please and thank you!

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481
    Are you wanting to have a new record adopt the last entry as the defaults?
    If so, there is a thread on that subject.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    hertfordkc, I think OP said all fields are in same record. That sure doesn't make sense - why would the part number be repeated in the same record?

    jlgray, Do you really want what hertfordkc described?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Multiple forms or embedded sub-forms
    By Juicejam in forum Forms
    Replies: 2
    Last Post: 08-23-2011, 07:31 AM
  2. Replies: 1
    Last Post: 01-04-2011, 05:04 AM
  3. Search forms and sub forms
    By FadingAPE in forum Forms
    Replies: 1
    Last Post: 12-15-2010, 01:59 PM
  4. Replies: 4
    Last Post: 04-01-2009, 08:49 PM

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