Results 1 to 5 of 5
  1. #1
    no--limits is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    3

    Post Add value from form to table

    Greetings!!!



    I am newbie in Access, so I need a little of your assistance.

    I have a form, let's say it is called "MyForm" which includes multiple textboxes that are connected with a table called "MyTable".

    Every time that I want to have data from one of my textboxes to a specific field of "MyTable", I add this field to the Control Source in the Data Section of properties of my textbox and I achieve it.

    Now, there is a textbox in which I want to have multiple if functions and the final result to be added to a specific field of "MyTable".

    Let's say that the if function in my Text83 (textbox) is the following:

    IIf([SUM]<=5;"Low";"High") (The SUM textbox, is a textbox which makes calculations all the time, depending on the values that the user adds)

    Now I need the result of Text83, either if it is Low or High, to be added to the field "Result" of "MyTable".

    I already tried by having as Control Source "Result" of "MyTable" and "default value" the iif function, but I only achieved adding the value that it is initially calculated and not the final value.

    Click image for larger version. 

Name:	Untitled.png 
Views:	4 
Size:	5.7 KB 
ID:	26141

    Is there anything you can suggest?

    Thanks in advance!!!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Why do you feel you need a calculated value in a table? It can easily be calculated in a query whenever you need it.

  3. #3
    no--limits is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    3
    Hello, thanks for your reply!

    I need to have it in the table because I want to store all the relevant info in this specific table.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Again, I will state that calculated field nelong in queries and not tables: http://allenbrowne.com/casu-14.html

  5. #5
    no--limits is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    3
    Oh, well... I created a query and now I will export the data from there. Thanks for your help!

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

Similar Threads

  1. Replies: 7
    Last Post: 09-27-2016, 10:54 AM
  2. Replies: 6
    Last Post: 12-13-2014, 09:20 PM
  3. Replies: 1
    Last Post: 07-01-2014, 01:41 PM
  4. Replies: 2
    Last Post: 10-07-2013, 11:01 AM
  5. Replies: 2
    Last Post: 08-01-2011, 11:35 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