Results 1 to 2 of 2
  1. #1
    Join Date
    May 2015
    Posts
    3

    Unanswered: Functions that should return the same result but do not

    I have two functions both should have the same results but they do not.


    Public Function DefaultGreeting() As String
    On Error Resume Next
    DefaultGreeting = "Dear " & [Forms]![frm_contacts]![Dear] & ":"
    End Function


    Public Function DefaultBodyText() As String
    On Error Resume Next
    DefaultBodyText = [Forms]![frm_e_mailing]![mess_text] / this equals this just pulled from a table "Dear " & [Forms]![frm_contacts]![Dear] & ":"
    End Function

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    and are you showing the same data on both forms at the same time, ie when you call the functions

    you are pulling the value of the control or column 'Dear' used in frm_contacts in one function
    and the
    you are pulling the value of the control or column 'mess_text' used in frm_e_mailing in the other
    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
  •