Results 1 to 2 of 2
  1. #1
    jopi is offline Novice
    Windows 8 Access 2013
    Join Date
    May 2014
    Posts
    20

    Form field that gets a value from a query calculated field

    Click image for larger version. 
<br /><script async src=
    Name: Form field that gets a value from a query calculated field.jpg  Views: 11  Size: 100.2 KB  ID: 17920" class="thumbnail" style="float:CONFIG" />

    I have a query that uses a calculated field from another query (“grouped by” afterwards)
    That gives a result
    And I need to automatically have this value, introduced in a form field

    However, when I write the path to this value in the form:
    =[Consulta_Totais]![Total_com_desconto]

    I get an error (Name?)

    What am I doing wrong? Can you please help?
    Than you.

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I have a query that uses a calculated field from another query (“grouped by” afterwards)
    That gives a result And I need to automatically have this value, introduced in a form field
    If the value is in the record source for the form (the query), you use the column name in the control source, just like any other field.

    So the Control Source for the text box would be "SomaDeTotal_com_descontrol" or "Total_com_descontrol". (without the quotes)

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

Similar Threads

  1. Calculated Field in Query
    By roarcrm in forum Queries
    Replies: 1
    Last Post: 06-06-2014, 09:24 AM
  2. Replies: 4
    Last Post: 03-20-2014, 03:52 PM
  3. Calculated Field in Form
    By jkbyerly in forum Forms
    Replies: 15
    Last Post: 02-20-2014, 10:20 PM
  4. Replies: 1
    Last Post: 04-21-2013, 03:20 PM
  5. Replies: 3
    Last Post: 02-13-2013, 10:15 AM

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