Results 1 to 3 of 3
  1. #1
    Rze is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    1

    Combo Box doesn't see fields on source form

    I am new to access and self teaching.


    Trying to create a form on which I want to add a field for "Employee". I have a separate table called "Employees". When I use the combo tool (Table design view) and select "I want the combo box to get the values from another table or query", I then select the Employees table and it only shows ID and LOCATION as selectable fields.

    On the table, I actually have:
    ID
    Employee Last Name
    Employee First Name
    Location

    Why cant I see Employee First and Last name as selectable field?

    Thanks for the education!

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    you're creating a lookup field in a table? - don't!
    The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Further to micron's advice, do NOT use names that have embedded spaces --they will come to haunt you.

    Consider:
    Employee Last Name ===> EmployeeLastName
    or ===============>Employee_Last_Name

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 04-26-2020, 02:33 AM
  2. Replies: 5
    Last Post: 01-20-2018, 03:40 PM
  3. Replies: 2
    Last Post: 03-18-2016, 08:39 AM
  4. Replies: 2
    Last Post: 02-26-2015, 03:20 PM
  5. Replies: 11
    Last Post: 08-08-2013, 03:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums