Hi,
Heres my problem: I am using Access 2000 and I have a main form, with a subform and on the subform is a further subform. Everything works great, and as the data is entered into each field certain form and/or field propertys are set in code depending on what the user does or selects.
What I need to happen is when the user moves from the current record in the MAIN form (which we can call frmMain)
by clicking the navigation buttons I need to trigger certain events that will in effect "reset" the form back to the original propertys that were in place before the user entered any data (so that the form is ready for the next record).
In short, how do I assign a event to the standard Access form navigation buttons (is this is possible).
Any help would be great.
Thank you in advance,
KennyUK
Heres my problem: I am using Access 2000 and I have a main form, with a subform and on the subform is a further subform. Everything works great, and as the data is entered into each field certain form and/or field propertys are set in code depending on what the user does or selects.
What I need to happen is when the user moves from the current record in the MAIN form (which we can call frmMain)
by clicking the navigation buttons I need to trigger certain events that will in effect "reset" the form back to the original propertys that were in place before the user entered any data (so that the form is ready for the next record).
In short, how do I assign a event to the standard Access form navigation buttons (is this is possible).
Any help would be great.
Thank you in advance,
KennyUK