Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Cleveland USA
    Posts
    184

    Angry Unanswered: What's wrong with this simple expression?

    I have a control on a report called txtEmployeeFullName. The report is called from a form and is based off a query. I want to concactenate the employee's FirstName, MiddleName and LastName. If I set the control equal to "tblEmployees.FirstName", it works fine. If I change the value to "=tblEmployees.FirstName", it doesn't work, which means I can't combine the full name. I am specifying the table's name because there's also a tblCustomers.FirstName on the report. I want to do the same thing with the Customer's name, but cannot for the same reason.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Try to change the TextBox to a Lable, in the Open report name put

    Me.yourLableNam.Caption = firstName & ", " & lastName

  3. #3
    Join Date
    Aug 2003
    Location
    Cleveland USA
    Posts
    184

    Angry

    The box needs to be a text field since it's data. Right now, I'm just trying to print the current record on a form, but I'll probably evenutally use it for multiple records. This problem is frustrating because I think it just doesn't like the "Tables" reference. I even tried

    =Queries!qryPrintCurrentCommentRecord.tblEmployees .FirstName

    but that doesn't work either.

Posting Permissions

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