OnSearch

The OnSearch event occurs only if a linked or unlinked text box has code in the OnSearch event and the user clicks on the generated search command button. This is only possible in graphical mode. Any VBA code can be placed in this event, even if it is not specifically related to searching a data source.

Group: Events

Applies to: Text prompts

Syntax:

OnSearch(Rsp, Cancel)

Rsp (String) The value in the textbox if any

Cancel (Boolean) Set to True to NOT run the OnEnter event and put the focus back on the prompt