Where to find lookup wizard in access

Specify the table, query, or list of values that provides the values for the lookup field. When the Row Source Type property is set to Value List , this property should contain a list of values separated by semicolons. Specify the column in the row source that supplies the value stored by the lookup field. This value can range from 1 to the number of columns in the row source.

The column that supplies the value to store does not have to be the same column as the display column. Specify the number of columns in the row source that can be displayed in the lookup field. To select which columns to display, you provide a column width in the Column Widths property. Enter the column width for each column. The display value in a lookup field is the column or columns that are represented in the Column Widths property as having a non-zero width.

Specify whether you can edit the items in a lookup field that is based on a value list. When this property is set to Yes and you right-click a Lookup field that is based on a single column value list, you will see the Edit List Items menu option. If the lookup field has more than one column, this property is ignored. Name an existing form to use to edit the list items in a lookup field that is based on a table or query. Show only values that match the current row source when Allow Multiples Values is set to Yes.

Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. This step can be a little confusing at first. You need to add the field that contains the value you want to enter—for example, the CustomerID field—but you also want to add several fields that will display more meaningful information in the value list, such as the LastName and FirstName fields.

You can also add fields by selecting the field in the Available Fields list and clicking the arrow buttons to add or remove them from the Selected Fields list. The next step in the Lookup Wizard dialog box is selecting a sort order for your list. You can sort records by up to four fields, in either ascending or descending order. This next step allows you to adjust the width of the columns in your lookup list. To adjust the width of a column, drag its right edge to the width you want, or double-click the right edge of the column heading to get the best fit.

Use a combo box when people need to see all the choices from the list right away. For more information, see Add a combo box to a view. Access for Microsoft Access Access More Need more help?

Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Suppose, using the Employees table above, we decide to add a further field listing which department the employee works for. We create the following Departments table:. The Dept Code field is the primary key. This time, the list of values is drawn from a table, so the first option is selected.

In the next stage, the Departments table is chosen:. Although any number of fields may be selected, it is generally best to choose just two; the primary key whose value is being used and one other field that is unique to each record. In this case, as the department name is unique to each department, it is a good choice. At a minimum, just the primary key could be chosen if it is sufficiently user-friendly. If more than one field has been selected, then Access will hide the primary key column; it is assuming that this is not very user-friendly.

If the table does not have a unique field apart from the primary key , then best practice is to create a query, based on the table, with two fields in it; one the primary key, the other a calculated field combining two or more fields that together are unique.

In this way you can still use the Microsoft Access Lookup Wizard. For example, suppose we have an Orders table linked to the aforementioned Employees table.