Problem: Subform won't Allow Additions 
Author Message
 Problem: Subform won't Allow Additions

I'm playing with the Customer Orders form of the Northwind database
example.  When I set the Allow Additions property of the second
subform to Yes, nothing happens. (When things are working right, I'm
guessing that I should see one of those blank records with a * in it?
--Or be able to right-click in the upper-lefthand corner of the
subform and see the New Record option enabled?  Right?) I've saved the
database, closed and reopened it, and I still get the same result.

I have the same problem with the first subform.  Changing the Allow
Additions property of the main form, however, works as expected.
What's up?



Sun, 11 Apr 2004 16:36:22 GMT  
 Problem: Subform won't Allow Additions
Hi,

Wild guess...... the subform's "Allow Additions" property is overridden by
the main form.

Shaun.

Quote:
> I'm playing with the Customer Orders form of the Northwind database
> example.  When I set the Allow Additions property of the second
> subform to Yes, nothing happens. (When things are working right, I'm
> guessing that I should see one of those blank records with a * in it?
> --Or be able to right-click in the upper-lefthand corner of the
> subform and see the New Record option enabled?  Right?) I've saved the
> database, closed and reopened it, and I still get the same result.

> I have the same problem with the first subform.  Changing the Allow
> Additions property of the main form, however, works as expected.
> What's up?



Sun, 11 Apr 2004 23:59:31 GMT  
 Problem: Subform won't Allow Additions
Perhaps, the subform's recordset type is set to something like
Snapshot that doesn't allow additions?  Perhaps, the subform is based
on a query that has a construction that is incompatable with adding
records?



Quote:
>I'm playing with the Customer Orders form of the Northwind database
>example.  When I set the Allow Additions property of the second
>subform to Yes, nothing happens. (When things are working right, I'm
>guessing that I should see one of those blank records with a * in it?
>--Or be able to right-click in the upper-lefthand corner of the
>subform and see the New Record option enabled?  Right?) I've saved the
>database, closed and reopened it, and I still get the same result.

>I have the same problem with the first subform.  Changing the Allow
>Additions property of the main form, however, works as expected.
>What's up?



Mon, 12 Apr 2004 05:20:23 GMT  
 Problem: Subform won't Allow Additions
No; this definitely ain't it.
Quote:
> Hi,

> Wild guess...... the subform's "Allow Additions" property is overridden by
> the main form.



Mon, 12 Apr 2004 11:04:09 GMT  
 Problem: Subform won't Allow Additions
No, the recordset isn't set to Snapshot.  And the subform is based on
a table, not a query.

Interestingly, when I open the form that this subform is based on
(Subform 2 instead of Customer Orders) I /can/ enable and disable the
addition of new records.  It's only when used as a subform that Allow
Additions doesn't work.  It's important to me to figure out why this
is, because I'm trying to create just this type of relationship.

Quote:
> Perhaps, the subform's recordset type is set to something like
> Snapshot that doesn't allow additions?  Perhaps, the subform is based
> on a query that has a construction that is incompatable with adding
> records?



Mon, 12 Apr 2004 11:19:49 GMT  
 Problem: Subform won't Allow Additions

The default NWind mdb orders form and subforms *are* set to

AllowEdits = False
AllowAdditions = False
AllowDeletions = False

gary

Quote:

> No, the recordset isn't set to Snapshot.  And the subform is based on
> a table, not a query.

> Interestingly, when I open the form that this subform is based on
> (Subform 2 instead of Customer Orders) I /can/ enable and disable the
> addition of new records.  It's only when used as a subform that Allow
> Additions doesn't work.  It's important to me to figure out why this
> is, because I'm trying to create just this type of relationship.

> > Perhaps, the subform's recordset type is set to something like
> > Snapshot that doesn't allow additions?  Perhaps, the subform is based
> > on a query that has a construction that is incompatable with adding
> > records?



Mon, 12 Apr 2004 13:04:06 GMT  
 Problem: Subform won't Allow Additions
Yeah, I know.  I started this thread by saying that I /changed/ the
AllowAdditions setting.
Quote:
> The default NWind mdb orders form and subforms *are* set to

> AllowEdits = False
> AllowAdditions = False
> AllowDeletions = False



Mon, 12 Apr 2004 19:28:18 GMT  
 Problem: Subform won't Allow Additions

Quote:

> Yeah, I know.  I started this thread by saying that I /changed/ the
> AllowAdditions setting.

I know, which is why I said...

Quote:
> > The default NWind mdb orders form _*and*_ subforms *are* set to

> > AllowEdits = False        *****
> > AllowAdditions = False
> > AllowDeletions = False

gary


Tue, 13 Apr 2004 07:09:37 GMT  
 Problem: Subform won't Allow Additions
I don't follow you.  Let me restate what I think you're saying.

"By default, the Allow Additions property of the Orders form and
Orders Subform form of the Northwind database are both set to False."

Well, I'm looking at the property box for each of these forms right
now, and both Allow Additions attributes are set to Yes. (They don't
even accept values of False.)

Are you instead trying to point out that the subform in the Orders
form /does/ allow the addition of new records?  Okay, I see that.
However, the subforms in the Customer Orders form don't, even with the
Allow Additions property of these subforms set to Yes.  /This/ is
what's bothering me.

Quote:
> I know, which is why I said...

> > > The default NWind mdb orders form _*and*_ subforms *are* set to

> > > AllowEdits = False        *****
> > > AllowAdditions = False
> > > AllowDeletions = False

> gary



Tue, 13 Apr 2004 13:49:58 GMT  
 Problem: Subform won't Allow Additions
Nearly there,

AllowEdits = No on the mainform disables edits on the subs on account of
how you can't edit the controls on the MainForm - and a SubForm is just
a control.

Set everything to yes/true/0 ('cept data entry) and you'll be fine.

gary

Quote:

> I don't follow you.  Let me restate what I think you're saying.

> "By default, the Allow Additions property of the Orders form and
> Orders Subform form of the Northwind database are both set to False."

> Well, I'm looking at the property box for each of these forms right
> now, and both Allow Additions attributes are set to Yes. (They don't
> even accept values of False.)

You can read True /Yes /-1 for this
Quote:
> Are you instead trying to point out that the subform in the Orders
> form /does/ allow the addition of new records?  Okay, I see that.
> However, the subforms in the Customer Orders form don't, even with the
> Allow Additions property of these subforms set to Yes.  /This/ is
> what's bothering me.

> > I know, which is why I said...

> > > > The default NWind mdb orders form _*and*_ subforms *are* set to

> > > > AllowEdits = False        *****
> > > > AllowAdditions = False
> > > > AllowDeletions = False

> > gary



Tue, 13 Apr 2004 14:22:31 GMT  
 Problem: Subform won't Allow Additions
Ah, there we go!  Now I'm with you.  Thanks a lot.

--E.

Quote:
> Nearly there,

> AllowEdits = No on the mainform disables edits on the subs on account of
> how you can't edit the controls on the MainForm - and a SubForm is just
> a control.

> Set everything to yes/true/0 ('cept data entry) and you'll be fine.

> gary



Thu, 15 Apr 2004 07:58:27 GMT  
 
 [ 11 post ] 

 Relevant Pages 

1. Form won't allow edits or additions

2. 1-M Form won't allow additions!

3. 1-M form won't allow additions!

4. Subform won't allow deletions

5. Subform won't allow updates - but only when placed in Tab Control

6. Subform won't allow data entry - why??

7. Subform won't allow deletions

8. Subform won't allow updates - but only when placed in Tab Control

9. subform resets Allow Edits, Deletions and Additions to No

10. change Allow Additions to No on Subform


 
Powered by phpBB® Forum Software © phpBB Group