SubForm not allowing new records 
Author Message
 SubForm not allowing new records

I have a subform that is linking properly when I scoll through records on
the main form, but the subform will not let me add new records to it.  I
have Allow Edits, Deletions, Additions in both the main and subforms all set
to 'Yes'.  Any ideas on why this is happening ??

Thanks,

Stuart McClune



Wed, 26 Jun 2002 03:00:00 GMT  
 SubForm not allowing new records
Do you not have an empty line at the bottom of your subform, or are you
getting error messages when you try to write into it?

If your subform is based on a query, is it updateable?  Can you change
existing data in the subform?

- Turtle

Quote:

>I have a subform that is linking properly when I scoll through records on
>the main form, but the subform will not let me add new records to it.  I
>have Allow Edits, Deletions, Additions in both the main and subforms all
set
>to 'Yes'.  Any ideas on why this is happening ??

>Thanks,

>Stuart McClune



Wed, 26 Jun 2002 03:00:00 GMT  
 SubForm not allowing new records
Make sure the recordset property of the subform is set to Dynaset, not
snapshot.  If the subform is populated from a query, check the queries
recordset property as well.

I ran into a situation where I couldn't add new records.  All of the above
mentioned items were OK.  The underlying table did not have a primary key
defined.  When I defined one, it let me add records.  I have no idea why
that would make a difference or what other properties in conjunction with no
primary key would cause this.  Can someone explain that situation?

Dick K.



Wed, 26 Jun 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. SUBFORM NOT ALLOWING NEW RECORDS

2. Subform not allowing new record entry

3. subform not allowing new record

4. Access will not allow new record in a subform

5. Access will not allow new record in a subform

6. Navigation Buttons - Not Allowing New Record Creation with Next Record

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

8. Subform Not allowing addition of record

9. Updating subform to new record not overwriting old record

10. New Record not allowing data entry?


 
Powered by phpBB® Forum Software © phpBB Group