This statement is similar to the Pick function in that it generates a list of remote records defined by IndexName, SearchExpression, LowerExpression and UpperExpression. Any of SearchExpression, LowerExpression and UpperExpression may be MakeKey values.

Rather than reading value from the remote record, this statement writes a new value into the specified field (WritefieldName) in the remote record. ValueExpression supplies the new field value.

Apart from setting the field value, this statement also sets the SysReply system workarea

• 0 Value returned (as normal)
• -1 User pressed the Escape key, or chose the Cancel button
• -2 No response (timeout error)
• -3 Undefined error

Note that you:

• May use this statement to write to a record in the current table
• Cannot use this statement to write a picture field value

The following example allows the user to choose sixteen seeds for a forthcoming tennis match. The PickRecordWrite statement displays a list of players, with their ranking and country of origin.

for i = 1 To 16

PopupTitle "Choose seed no " & i
PickRecordWrite i, seed, ,SeedName, 0, 0, name, rank, origin

next