SubForm Allow Additions 
Author Message
 SubForm Allow Additions

Hi,

I have an access subfrom based on a query,
but the subform does not allow me add records even though
it Allow Additions property is set to Yes.

Any ideas ?

Thanks,
Mark



Mon, 30 May 2005 23:44:13 GMT  
 SubForm Allow Additions
Have you verified that the underlying query is updatable?

--
HTH
Dan Artuso, MVP

"A problem well stated is a problem half solved"


Quote:
> Hi,

> I have an access subfrom based on a query,
> but the subform does not allow me add records even though
> it Allow Additions property is set to Yes.

> Any ideas ?

> Thanks,
> Mark



Tue, 31 May 2005 00:13:49 GMT  
 SubForm Allow Additions
Hi Dan
Quote:
>-----Original Message-----
>Have you verified that the underlying query is updatable?

I have opened the subform as a form on its own, and it
allows me add, delete etc.
But it still will not let me add new.

Regards,
Mark.

Quote:
>--
>HTH
>Dan Artuso, MVP

>"A problem well stated is a problem half solved"



>> Hi,

>> I have an access subfrom based on a query,
>> but the subform does not allow me add records even
though
>> it Allow Additions property is set to Yes.

>> Any ideas ?

>> Thanks,
>> Mark

>.



Tue, 31 May 2005 00:41:42 GMT  
 SubForm Allow Additions
Hi Mark,
The main form is fine? You can add records to it?

--
HTH
Dan Artuso, MVP

"A problem well stated is a problem half solved"


Quote:
> Hi Dan
> >-----Original Message-----
> >Have you verified that the underlying query is updatable?
> I have opened the subform as a form on its own, and it
> allows me add, delete etc.
> But it still will not let me add new.

> Regards,
> Mark.

> >--
> >HTH
> >Dan Artuso, MVP

> >"A problem well stated is a problem half solved"



> >> Hi,

> >> I have an access subfrom based on a query,
> >> but the subform does not allow me add records even
> though
> >> it Allow Additions property is set to Yes.

> >> Any ideas ?

> >> Thanks,
> >> Mark

> >.



Tue, 31 May 2005 03:05:18 GMT  
 SubForm Allow Additions
Hi Dan,

The main form had the Allow Additions property set to
False, but when I set it to True, I can add records to the
main form, but not the subForm.

Thanks,
Mark

Quote:
>-----Original Message-----
>Hi Mark,
>The main form is fine? You can add records to it?

>--
>HTH
>Dan Artuso, MVP

>"A problem well stated is a problem half solved"



>> Hi Dan
>> >-----Original Message-----
>> >Have you verified that the underlying query is
updatable?
>> I have opened the subform as a form on its own, and it
>> allows me add, delete etc.
>> But it still will not let me add new.

>> Regards,
>> Mark.

>> >--
>> >HTH
>> >Dan Artuso, MVP

>> >"A problem well stated is a problem half solved"



>> >> Hi,

>> >> I have an access subfrom based on a query,
>> >> but the subform does not allow me add records even
>> though
>> >> it Allow Additions property is set to Yes.

>> >> Any ideas ?

>> >> Thanks,
>> >> Mark

>> >.

>.



Tue, 31 May 2005 18:22:16 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Subform allow addition

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

3. change Allow Additions to No on Subform

4. not Allowing Additions on subforms

5. Subform Not allowing addition of record

6. Problem: Subform won't Allow Additions

7. Is it possible to allow/not allow editing to certain fields in a subform

8. My forms will not allow additions and my tables get a + column

9. how do you allow additions in a sub form

10. Allow additions


 
Powered by phpBB® Forum Software © phpBB Group