update without addnew or edit

[chainedtodesk]

i have a form that is open through a switchboard with option 3 (edit mode) but when data is entered into the form and the user clicks close the error msg "update without addnew or edit" appears. i have checked that all of the edits and change options are "allow" but no matter what i try it will not allow them to close the form or save the data. i have looked through several threads but nothing has helped. this is access 2010, form is opening using a table not a query. Thanks

 

[genomon]

Does your table have a primary key defined?

Beir bua agus beannacht!

 

[chainedtodesk]

it did originally but i removed the primary option

 

[genomon]

Probably won't allow operations then. You can add back in some combination (clustered) and it should perform as expected.

Beir bua agus beannacht!

 

[chainedtodesk]

thanks genomon will work on that and see if it solves problem(s)