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


The information in this article applies to:

  • Microsoft Access 2002
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";1"
Setting the ColumnWidths property to 0" 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).

Modification Type:MajorLast Reviewed:11/6/2003
Keywords:kbprb KB278867
©2003 Microsoft Corporation. All rights reserved.