Add new Record using Data access page

[brent123]

I'm trying to create a data access page that will allow me to add a record. I've added a button that has the add new record operation, but when I click on the button I get an error saying that I can't add a new record because the recordset is read only. In the group properties level I have allow addition equal to true. Are there any other setting I need to set. Why can't I add a record?

 

[fneily]

If your DAP is based on a table, you must place the PRIMARY KEY on the DAP. If it's based on a query, make sure your query is updatable (again, supply all the primary keys of the tables involved).

 

[brent123]

Yes, I just figured that out. Thanks for the help.