Locate Record Dialog Box

See Also

Searches for a record in the active table or view that matches specified conditions. Use this command when you want to search a table or view record-by-record on an indexed or unindexed field, or when you want to find more than one record in a table.

This dialog box appears when you choose the Locate command from the Go to Record submenu.

Dialog Box Options

Scope

Allows you to specify the records on which Visual FoxPro is to act. Choose All, Next, Record, or Rest from the drop-down list. Choose a number from the spinner on the right when you select Next or Record from the Scope drop-down list.

For

Displays the Expression Builder dialog box, in which you create the logical expression that every record must meet to be affected by the command.

While

Displays the Expression Builder dialog box. The While expression specifies that the action affects records only as long as the logical expression is true. The first time the expression evaluates to false, the action ceases without considering remaining records.

Locate

Carries out the command using the Scope, For, and While values.