MS Access, SubForm not allowing new records

SubForm not allowing new records

Author	Message
Stuart McClun #1 / 3	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

Turtl #2 / 3	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

Dick Kusleik #3 / 3	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

Page 1 of 1

[ 3 post ]