1. Create a form.

2. Create a button, hotspot, or action to store the @PickList formula.

3. For an action, choose View - Action Pane and then click the action. For button or hotspot, click the form and then click the button or hotspot.

4. In the Objects tab on the Info list in the Programmer’s pane, select the Click method for the button, hotspot, or action.

5. In the Script area of the Programmer's pane, make sure you have selected Run - Client - Formula.

6. Write a formula using @PickList and the [Custom] parameter, unless you want to use [Name] to display an IBM® Lotus® Domino(TM) directory or personal name and address book.

7. Close and save the form.

Using @PickList

The @PickList function looks up the values in a view as @DbColumn does, but lets the user pick a value from one document. This function is similar to using @Prompt in a form, but is specifically for use with views.

@Picklist offers the following advantages over formulas that use @DbColumn or @DbLookup.

• It is not limited to 64K of data.
• It is faster than @DbColumn or @DbLookup.
• It allows users to type the first few characters of an entry to find it quickly in the view.

This formula displays the Products view of PROD.NSF in a dialog box:

choice:=@PickList([Custom] ; "":"prod.nsf" ; "Products" ; "Select a product" ; "Please select the products you want to order" ; 1 );

See Also

Forms that prompt users for input
Designing a form that presents a dialog box
Designing a form that prompts users for information
Designing fields that prompt users to select folders

Glossary