How to Prevent users from leaving record line unfilled

mba_110

Registered User.
Local time
Yesterday, 21:30
Joined
Jan 20, 2015
Messages
280
Hi

I have form with subform in main form i have Entries and subform is transactions each entry have many transactions associated to it, subform is continues form.

I want to restrict user from leaving the transaction line blank unless they fully provide all required information on it.

I have put code isnull and cancel = true in last fields event but still user can just click on next line and put the entry number and go again to next line and leave the before line uncompleted.

I want new line should not be appear unless the current record row is completed or if even its appearing then their should be some code or event to give user message and prevent them to jump on next row.
 
You have to write your code in the Before-update event of the form not the fields.
 

Users who are viewing this thread

Back
Top Bottom