When I select the Lookup Wizard option in Access, I encounter Path Not Found

2024-04-23T18:08:38.11+00:00

Capture

Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
5,485 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,702 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
881 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ken Sheridan 2,841 Reputation points
    2024-05-10T11:37:25.01+00:00

    Most experienced Access developers recommend that the Lookup Field Wizard be avoided.  For reasons why see: 

    http://theaccessweb.com/lookupfields.htm 

    The same functionality can be achieved by binding a combo box to the column in question in a bound form, which is where data should be entered/edited, not in a table's datasheet view.  For example,  for an EmployeeID foreign key column a combo box could be set up as follows: 

    ControlSource:   EmployeeID 

    RowSource:     SELECT EmployeeID, FirstName & " " & LastName FROM Employees ORDER BY LastName, FirstName; 

    BoundColumn:   1

    ColumnCount:    2

    ColumnWidths:  0cm

     

    If your units of measurement are imperial rather than metric Access will automatically convert the unit of the last one to inches.  The important thing is that the dimension is zero to hide the first column. 

    Alternatively, you can concatenate the names so that the last name is first, which would be better with a large list of names as it allows the user to enter the initial characters of the last name and progressively go to the first match as each character is entered: 

    RowSource:     SELECT EmployeeID, LastName & ", " & FirstName FROM Employees ORDER BY LastName, FirstName;

     

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.