Software

Ask something
Discussion Locked

Access Forms

0 helpful
7 replies

by m*lenium

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am attempting to modify a form to display a message (eg. Help Me). The message should only display when the specified field (eg. price) value is greater than 1000.

Can someone Please, Please assist me with this? I am eternally grateful.

7 replies

by dklippert

In Design mode look at properties. (Right click and choose Properties)
On the Data tab enter <1000
In the Validation text box type your message

by seagull data services

You can use the beforeupdate and afterupdate event procedures to do just about anything.
The beforeupdate event fires off before the data is updated (hence the name) this can be useful if you want the opprotunity to revert to the field without making any changes.
The afterupdate event fires off after the data has been saved. If you just want a notification to appear, this is the place to do it.
HTH
John

This discussion is closed to new replies.