A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Strange: data puts form in state that prevents subform editing?



 
 
Thread Tools Display Modes
  #1  
Old April 21st, 2008, 01:22 PM posted to microsoft.public.access.forms
The Dude
external usenet poster
 
Posts: 30
Default Strange: data puts form in state that prevents subform editing?

Hello all,

I have a question regarding the state of a form:
I have a form with a subform in DS view, and when I enter data in the main
form then I cannot edit anything in the subform.
If I empty completely the main form, then my subform becomes available for
editing...

So my question is to know if there is a state or event on a form that
triggers when you start entering data?
Note that I have set the record lock to Edited Record in both form/subform.

Thanks in advance :-]
TD
  #2  
Old April 21st, 2008, 06:28 PM posted to microsoft.public.access.forms
Maurice
external usenet poster
 
Posts: 1,585
Default Strange: data puts form in state that prevents subform editing?

My guess would be the "Dirty" state of the form. Maybe the subform is
strictly depended on the key of the mainform and it will only allow edits
when the fk is assigned.

Sometimes it helps to force the state of the form by setting its state to
me.dirty=false when a certain field has been filled (the pk for sure) and
maybe an additional field.

--
Maurice Ausum


"The Dude" wrote:

Hello all,

I have a question regarding the state of a form:
I have a form with a subform in DS view, and when I enter data in the main
form then I cannot edit anything in the subform.
If I empty completely the main form, then my subform becomes available for
editing...

So my question is to know if there is a state or event on a form that
triggers when you start entering data?
Note that I have set the record lock to Edited Record in both form/subform.

Thanks in advance :-]
TD

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.