Microsoft KB Archive/278867

= ACC2002: Lookup Wizard Is Not Available in Access Projects (ADPs) =

Article ID: 278867

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q278867



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
The Lookup Wizard that is available in an Access database (MDB) is not available in an Access project (ADP). However, in an Access project, you can set lookup properties manually to provide lookup functionality in an ADP.



RESOLUTION
You must set properties that are typically set by the Lookup Wizard in an Access database (MDB) manually in an Access project (ADP). These properties include the RowSource, BoundColumn, ColumnCount, and ColumnWidths properties.



MORE INFORMATION
Because lookup properties for a field limit the choices available, data entry is more reliable when you set the lookup properties. Data entry is also easier because data in the related table is automatically displayed.

For example, you can have the CompanyID field in the Northwind Orders table display the company name as a lookup by setting the following properties in the table's design:   Table: Orders --  Field Name: CompanyID Display Control: Combo Box Row Source Type: Tables/Views/Functions Row Source: SELECT CompanyID, CompanyName FROM Customers ORDER BY CompanyName Bound Column : 1 Column Count : 2 Column Widths: 0&quot;;1&quot; Setting the ColumnWidths property to 0&quot; for the first field hides the primary key of the CompanyID field in the combo box and instead displays the company name.

You can enter a value directly into the RowSource property box, or you can start the Query Builder and build a query by selecting and sorting the appropriate fields. To start the Query Builder, click the Build button (...) to the right of the RowSource property box.

NOTE: You can only set lookup properties when the data source for the Access project is Microsoft SQL Server 2000 (including Microsoft SQL Server 2000 Desktop Engine).

NOTE: The previous version of Microsoft SQL Server 2000 Desktop Engine is named Microsoft Data Engine (MSDE).

Additional query words: prb look up unavailable

Keywords: kbprb KB278867

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.