Web Development

Ask something
Discussion Locked

MS Access Continous Forms Usage

0 helpful
3 replies

by tomc

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

I have a form defined as a "Continous Form". For each row displayed on the form I would like to define some business validation rules for existing row changes or new row additions.
From what I have been able to ascertain, I can trap the event of moving from row to row, but I cannot trap the before update of that row I am moving off of.
Is there away to accomodate these requirements?

3 replies

by richtee

You can use the "on Exit" event in the field that is the last 'tabbed field' for the row on your form.

You can put your code here to run your validation before going to the next record (next row).

Hope this gets you on your way. Rich

This discussion is closed to new replies.