I have a query with 100 records.
Field "nr" is numbered 1 to 100.
When I choose an existing value for nr, the associated fields of the record are displayed on a form.
However I would like to display a message box when a value greater than 100 is chosen. ( there is no record where nr>100).
How can I achieve this ?
( this is a simplified example of the real thing - I may not exclude values >100 with fi a validation rule)
Field "nr" is numbered 1 to 100.
When I choose an existing value for nr, the associated fields of the record are displayed on a form.
However I would like to display a message box when a value greater than 100 is chosen. ( there is no record where nr>100).
How can I achieve this ?
( this is a simplified example of the real thing - I may not exclude values >100 with fi a validation rule)