Is there an event for moving from one record to the next

[jpl458]

That's clever. Xor would work correctly in VB
A= 11
B= 00

Xor a,b a=11 (Syntax would be a= a xor b)
Xor b,a b= 11
Xor a,b a=00

Not a proof, but a slick process.

I use XOR in simple encryption.
A xor bitmask = B
B xor bitmask = A

Glad you liked it. That puzzle is older than dirt. Back in the olden days we used that trick to double buffer I/O. The mainframe could fill the buffer faster than the disk could write it, so we would use 2 buffer areas, and eliminate the wait for the buffer to refill before writing it to disk. Those were the days when you were very close to the machinery. Not like today, when some users think the screen is the computer.

 

[Pat Hartman]

Minor epiphany.

It only took 11 years But, you are absolutely correct. The Class module of the form controls data fetching/updating, scrolling, rendering all the objects, etc. Under certain conditions (events), you are given the opportunity to add your own code to customize the form's actons. The most important of all of the available form level events is the form's BeforeUpdate event. Think of this as the flapper at the bottom of a funnel. You get to write validation code that determines whether the flapper is open (record gets saved) or closed (record does NOT get saved). The BeforeUpdate event is triggered by Access as well as by you. You can ask Access to save the record or Access can decide of its own volition that the data must be saved before moving on and so it will fire the BeforeUpdate event so you get an opportunity to validate the data and decide whether or not it should be saved.

 

[spaLOGICng]

I have a form that allows the user to scroll through the records using the < > at the bottom of the form. The question is, is there an event that fires on changinh to a new record while scrolling. I've tried the after update, before update, all to no avail.

Thanks

After reading the original post and some your replies below, here is my 2 cents.

Enable Editing on the Form
Disable Adding New Records
Disable Deleting Records
Lock all of the Controls except for the Combo box.

You can have additional actions triggered if needed on the Before or After Update Event on the Combo box.