How to do an "On change record" event??
but what of there is no update to the data? the form and its record are
just being viewed?
on current checks the record AFTER it changes. I want to PREVENT the
changing of records UNTIL the problem has been addressed/corrected.
Quote:
> Take a look at the Form's Before Update event.
> > Is there a way to run code when the user requests to change records,
then
> > cancel is a problem is found?
> > I know I can make my own record forward and back buttons that can
> intercept
> > the command, but I like using the access navigation buttons. when the
> users
> > clicks to move forward a record, I want to run some queries to verify
data
> > is correct before allowing user to move off the current record.
> > thanks
> > james
