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  

Why does it keep changing back?



 
 
Thread Tools Display Modes
  #11  
Old December 23rd, 2008, 02:36 PM posted to microsoft.public.access.forms
ZigZagZak
external usenet poster
 
Posts: 46
Default Why does it keep changing back?

Holy cow guys!....To answer one of the questions, yes I was changing it in
design view through the properties box, yes I had "allow addditions" marked
as yes as well. I will try some of the things that were suggested though,
thanks for all the replies!!!

"Dale Fye" wrote:

Are you trying to do this via code?

I had a similar problem a while back, where I had a subform in continuous
mode (AllowAdditions = False), and what I wanted to do was put the subform
into data entry mode when the user clicked an "Add" button.

What I found was that IAW Access Help, "The DataEntry property has an effect
only when the AllowAdditions property is set to Yes"

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



"ZigZagZak" wrote:

Hello-
Getting kinda frustrated with a form......
I have a main form & a subform. The subform I want to be an entry
form...but when I put it to "data entry" in the properties, it keeps changing
back to not a data entry form..........


WHY???? haha its making me crazy!

thanks!

  #12  
Old December 26th, 2008, 02:56 PM posted to microsoft.public.access.forms
TekWarrior
external usenet poster
 
Posts: 10
Default Why does it keep changing back?

If your still having issues after trying all those above you might look at
how you have your record locking setup, since it appears your main form is
using the same table as your subform it is possible that Access is preventing
the subform from being a data entry form due to record locking.

Also if you are using a query for the subform (you should always use queries
and not tables directly as thats more versatle for making changes without
"redesigning"), and your underlying query is not an "editable" query (i.e.
you can edit or add data) then the form (or subform in this case)
atomatically becomes uneditable.

Just another couple thoughts of what to look at..
--

Thanks,
Tek


"ZigZagZak" wrote:

Holy cow guys!....To answer one of the questions, yes I was changing it in
design view through the properties box, yes I had "allow addditions" marked
as yes as well. I will try some of the things that were suggested though,
thanks for all the replies!!!

"Dale Fye" wrote:

Are you trying to do this via code?

I had a similar problem a while back, where I had a subform in continuous
mode (AllowAdditions = False), and what I wanted to do was put the subform
into data entry mode when the user clicked an "Add" button.

What I found was that IAW Access Help, "The DataEntry property has an effect
only when the AllowAdditions property is set to Yes"

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



"ZigZagZak" wrote:

Hello-
Getting kinda frustrated with a form......
I have a main form & a subform. The subform I want to be an entry
form...but when I put it to "data entry" in the properties, it keeps changing
back to not a data entry form..........


WHY???? haha its making me crazy!

thanks!

 




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 08:12 AM.


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