Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2015
    Posts
    15

    Unanswered: Calculated Field from Two Forms...?

    So, I am trying to calculate two fields from two different forms.

    I get the math, but not the adressing

    So far I've tried this:

    Me.txtPSah.Value = Round(rs.Fields("AV") / Me.fTall.txtDA.Value * 100, 1) & "%"

    Where "AV" refers to a sql run in this form, and the "fTall" is the other form I want to get some numbers from.

    Is this possible? Or do Ihave to run a sql to get the numbers in this form to? =)

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    instead of using me. you need to use the forms collection to refer to a variabel or control in another form
    forms!fTall.txtDA.Value * 100, 1) & "%"

    ....if it were a report then
    reports.myreportname.txtDA.Value * 100, 1) & "%"
    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
  •