I have created an Access form using the Wizard and added to subforms. The intent of the form is for data entry. It works great to review and change existing records but does not allow the addition of a new record. Which form property do I need to change to allow the creation of a new record?
-
-
There is a form property in the Data tab that is called Allow Additions. This needs to be set to Yes. However, it might already be set to Yes and still not allow you to add records if the recordset that the form is based on cannot be edited. My guess would be that this is what has happened in your case. Is the form based on a table or query? If a table, is the table an Access table or do you have some other backend? If a query, please post the SQL (assuming that the Allow Additions property doesn't fix it). -
We will need the underlying record sources for the forms.
Often it is that the record source is not updatable.Comment
-
I am building a prototype database. All of the tables were created in Access and at this point I only have 4 records in the main database. I have a couple of other tables created with a one to many relationship to the parent. The form property called Allow Additions is already set to yes. The form in question has a seven fields and a photo identifying an individual. There are 2 subforms. one to record multiple phone numbers for the individual and the second to record multiple email addresses for the individual. Any other ideas. ThanksComment
-
Once again,
Please post the record sources being used.
Until we understand how the forms are related to the tables we will not be able to help you.Comment
Comment