If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Sub-Form Properties Changed...
I have a data entry form with a sub-form. Somehow on ocassions, which I
can't track, the sub-form properties: Allow Edits, Alllow Deletions and Allow Additions, gets changed. I've been trying to observe users and their habits for the past few months, in the hope of trying to figure out the reason for these changes. Somehow I can't figure out what would cause these changes. There is nothing in the form coding that even addresses these properites. Is there someone out there who can explain this so that I can fix this problem for good? Right now, I have to go and change the properties manually everytime this happends. Thanks, Fred |
#2
|
|||
|
|||
Sub-Form Properties Changed...
I'm pretty sure a SubForm inherits these settings from the MainForm. Does
that help at all? Fred wrote: I have a data entry form with a sub-form. Somehow on ocassions, which I can't track, the sub-form properties: Allow Edits, Alllow Deletions and Allow Additions, gets changed. I've been trying to observe users and their habits for the past few months, in the hope of trying to figure out the reason for these changes. Somehow I can't figure out what would cause these changes. There is nothing in the form coding that even addresses these properites. Is there someone out there who can explain this so that I can fix this problem for good? Right now, I have to go and change the properties manually everytime this happends. Thanks, Fred -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
#3
|
|||
|
|||
Sub-Form Properties Changed...
The Subform's orginal property always changes after a few weeks of usage.
Even if it the Subform inherits the MainForm's property, what would change the property of the Subform? Why wouldn't the Subform's property change immediately? "ruralguy via AccessMonster.com" wrote: I'm pretty sure a SubForm inherits these settings from the MainForm. Does that help at all? Fred wrote: I have a data entry form with a sub-form. Somehow on ocassions, which I can't track, the sub-form properties: Allow Edits, Alllow Deletions and Allow Additions, gets changed. I've been trying to observe users and their habits for the past few months, in the hope of trying to figure out the reason for these changes. Somehow I can't figure out what would cause these changes. There is nothing in the form coding that even addresses these properites. Is there someone out there who can explain this so that I can fix this problem for good? Right now, I have to go and change the properties manually everytime this happends. Thanks, Fred -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 . |
#4
|
|||
|
|||
Sub-Form Properties Changed...
Do you use DoCmd.Close acForm, Me.Name, acYes anywhere?
Fred wrote: The Subform's orginal property always changes after a few weeks of usage. Even if it the Subform inherits the MainForm's property, what would change the property of the Subform? Why wouldn't the Subform's property change immediately? I'm pretty sure a SubForm inherits these settings from the MainForm. Does that help at all? [quoted text clipped - 11 lines] Thanks, Fred -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
#5
|
|||
|
|||
Sub-Form Properties Changed...
Yes I use those in the Main Form only...not the subform with the problem...
"ruralguy via AccessMonster.com" wrote: Do you use DoCmd.Close acForm, Me.Name, acYes anywhere? Fred wrote: The Subform's orginal property always changes after a few weeks of usage. Even if it the Subform inherits the MainForm's property, what would change the property of the Subform? Why wouldn't the Subform's property change immediately? I'm pretty sure a SubForm inherits these settings from the MainForm. Does that help at all? [quoted text clipped - 11 lines] Thanks, Fred -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 . |
#6
|
|||
|
|||
Sub-Form Properties Changed...
Are you aware that the acYes at the end is for saving changes to the *form*
and not for saving the current record? It should really be: DoCmd.Close acForm, Me.Name, acSaveNo Fred wrote: Yes I use those in the Main Form only...not the subform with the problem... Do you use DoCmd.Close acForm, Me.Name, acYes anywhere? [quoted text clipped - 8 lines] Thanks, Fred -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 |
Thread Tools | |
Display Modes | |
|
|