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 |
#11
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|