Record Change

[DBFIN]

I have a Form with data entry property = No. If a user clicks the page down button accidently, this could move the form to the next record even when cycle property = current record. I want to create a macro that fires a message whenever the user clicks page down and moves to the next record.

Question1:Is there an event that is somehow linked to a user moving into the next record.

Question2: Alternatively is there a way I can store the record number in a form textbox. How can the record number be captured via a simple macro action ?

Thanks in advance for your ongoing support !!

 

[DBFIN]

I believe I answered my own question. I created a text box called "Record Number" and made the control source = CurrentRecord. I can use this textbox to create a macro that fires whenever Record Number does not equal 1.