Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    117

    Unanswered: Keep Getting the #Name error

    I am trying to make a form that has some boxes you manually type in things but others is selected from drop down box. The form is pulling from different tables and I notice that its not liking that idea too much. I am trying to see what I may be doing wrong. Also, trying to get a box to pull up the person first name and last name.....I know I use EmployeeFirstName ?????? EmployeeLastName.....I am not sure what goes in between the two expressions.

  2. #2
    Join Date
    Oct 2002
    Location
    NSW Australia
    Posts
    61

    Re: Keep Getting the #Name error

    [/SIZE][/QUOTE]EmployeeFirstName ?????? EmployeeLastName.....I am not sure what goes in between the two expressions. [/SIZE][/QUOTE]


    You should build the rowsource using te wizard.In the query builder in a blank FIELD type:
    name: [EmployeeFirstname] & " " & [EmployeeLastname]


    HTH :0)

Posting Permissions

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