S
Sandra
I must confess that I am somewhat new to Access VB but I
have done lots of programming in other languages, so I
sorta know what I want to happen, I just don't know how
to get there in Access LOL!
I am writing a DB that will be used by staff and
volunteers who have minimum DB skills. I want to protect
the security of each record to avoid "mis-edits" when
using Find, etc. I found it was simple enough to use
AllowEdits and AllowDeletions as False in the On Current
property for this and have an EDIT button to allow
editing each record, but I have one problem.
One of my forms has 2 subforms that are entered by an
AfterUpdate event based on the values of a field in a
combo box. Upon exiting the subform and re-entering the
form, the On Current event proc has changed the
AllowEdits back to false so you can't complete the form.
So, what I *think* I need is some switch or qualifier
like an IF, WHILE or whatever that would negate or
suspend the On Current event when the user moves to the
subforms and back. Is this clear as mud LOL?
TIA,
Sandra
have done lots of programming in other languages, so I
sorta know what I want to happen, I just don't know how
to get there in Access LOL!
I am writing a DB that will be used by staff and
volunteers who have minimum DB skills. I want to protect
the security of each record to avoid "mis-edits" when
using Find, etc. I found it was simple enough to use
AllowEdits and AllowDeletions as False in the On Current
property for this and have an EDIT button to allow
editing each record, but I have one problem.
One of my forms has 2 subforms that are entered by an
AfterUpdate event based on the values of a field in a
combo box. Upon exiting the subform and re-entering the
form, the On Current event proc has changed the
AllowEdits back to false so you can't complete the form.
So, what I *think* I need is some switch or qualifier
like an IF, WHILE or whatever that would negate or
suspend the On Current event when the user moves to the
subforms and back. Is this clear as mud LOL?
TIA,
Sandra