No announcement yet.

Combo Box Query Search

  • Filter
  • Time
  • Show
Clear All
new posts

  • Combo Box Query Search

    Hey everyone!

    I'm just getting into using access and I've come to my first road block with the combo box query search.

    I have a table with [FirstName][LastName][EmpID] then I set a query with
    Full_Info: [Rank] & " " & [EMP_L_Name] & ", " & Left([EMP_F_Name],1) & " " & [Emp_ID]

    When I made my custom query using the combo box search just for last names, it worked. The problem is having people with the same name so I set the query to use the query Emp_Extended for the drop down
    I'm sure the problem is something related to the bound column and its just for asthetics that I set it up this way.
    I could have just set the query to [LastName][FirstName] [EmpID] and had 3 columns in the drop down list.

    Hopefully my question makes sense?
    I wasn't entirely sure what to search for to find the answer to the problem im having, if you could point me in a direction that would be great!

    Thank you!

  • #2

    Fixed my problem.

    On the table I was searching for specific employee names, I changed the way the data was inputted and now its in the same format as I'd like to search with the drop down box