How to do an "On change record" event?? 
Author Message
 How to do an "On change record" 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



Mon, 06 Jan 2003 03:00:00 GMT  
 How to do an "On change record" event??
Take a look at the Form's Before Update event.


Quote:
> 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



Mon, 06 Jan 2003 03:00:00 GMT  
 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



Mon, 13 Jan 2003 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Table cell change "event"?

2. "Change in record selection formula detected"

3. "Database Has Changed" Event

4. OpenRecordset("Table",dbOpenTable) locks record changes?

5. "Database Has Changed" Event

6. Help deleting records "look" empty records

7. Recording a "record" in a database

8. Recording a "record" in a database

9. records "run over" other records

10. Doing "Stuff" in the background

11. Wait until done "thinking"?

12. Wait until done "thinking"?

 

 
Powered by phpBB® Forum Software