Results 1 to 4 of 4
  1. #1
    Join Date
    May 2012
    Posts
    132

    Unanswered: form / query relationship

    There is a query named query1, which has a column named “salary”.
    We also have a form with a textbox named “payements”.
    Can we design the form so that when it is loaded the textbox named payments gets the sum of column salary of query1?
    I mean: “payments” in form textbox = sum of “salary” column from query1
    ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    I asked god to please give me everything to enjoy the life, God said: i gave you the life to enjoy everything.

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    in the form design ,properties, in data tab, set the RECORD SOURCE = query1
    now you can select the txtbox
    and set its CONTROL SOURCE = salary

  3. #3
    Join Date
    May 2012
    Posts
    132
    Quote Originally Posted by ranman256 View Post
    in the form design ,properties, in data tab, set the RECORD SOURCE = query1
    now you can select the txtbox
    and set its CONTROL SOURCE = salary
    the problem is that the form is based on another table and not query1.
    ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    I asked god to please give me everything to enjoy the life, God said: i gave you the life to enjoy everything.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    use a domain function such as dcount or perhgaps more likely dsum
    OR
    open a recordset in the forms on current event that populates the control as required from that recordset
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •