Results 1 to 3 of 3
  1. #1
    New.User is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    37

    Calculated fields in form.

    Hello everyone,

    I am looking for a calculated field where in there is an addition of -1 (not a minus sign, it is a hyphen) for every new record I add.
    For example for a New Equipment field I manually enter Eqpt-123 and for the next field Sub Equipment there must be an auto populated value that says Eqpt-123-01. How do I do it?



    Regards
    New.User

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Add this code in the after update event of your New Equipment control

    Code:
    Me.[Sub Equipment]=Me.[New Equipment] & "-01"
    That's assuming you are adding -01 rather than -1 as you wrote both versions.

    Recommend you do not use spaces in field names or control names
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    New.User is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    37
    Thank you again Ridders.

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

Similar Threads

  1. Replies: 12
    Last Post: 10-01-2013, 12:59 PM
  2. Calculated Fields in Entry Form
    By Rhubie in forum Forms
    Replies: 1
    Last Post: 09-05-2012, 01:17 PM
  3. Replies: 0
    Last Post: 02-24-2012, 11:16 AM
  4. Replies: 1
    Last Post: 05-04-2011, 03:51 PM
  5. Calculated fields in form
    By speckytwat in forum Access
    Replies: 15
    Last Post: 04-27-2011, 05:01 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