Tupacmoche
Registered User.
- Local time
- Today, 10:35
- Joined
- Apr 28, 2008
- Messages
- 291
Form Masters,
I have a slit form let's call it formB that gets data automatically from another form let's call it formA upon saving. Users now want to do manual enter into formB so I've added a button labeled 'Add Item' When this button is clicked the caption is changed to 'Save and Exit'. I have vba code to disable most of the buttons including navigation buttons when the caption is changed while editing. When done the caption is changed back to 'Add Item' and this triggers the buttons to become enabled.
Now to the issue. Since the form is split it is possible for a user to change records on the record gird. So, the vba code to change the captions is by passed and the buttons remain disabled. Any suggestions on how to prevent this?
I have a slit form let's call it formB that gets data automatically from another form let's call it formA upon saving. Users now want to do manual enter into formB so I've added a button labeled 'Add Item' When this button is clicked the caption is changed to 'Save and Exit'. I have vba code to disable most of the buttons including navigation buttons when the caption is changed while editing. When done the caption is changed back to 'Add Item' and this triggers the buttons to become enabled.
Now to the issue. Since the form is split it is possible for a user to change records on the record gird. So, the vba code to change the captions is by passed and the buttons remain disabled. Any suggestions on how to prevent this?