chainedtodesk
Programmer
i have a database running in access 2007 (split db) with a frontend and backend. the switchboard is setup with an add button and an edit button. button 1 the add - opens a form with switchboard option = 2 and it allows users to add new records. button 2 the edit - opens a form with switchboard option = 3 but they can not edit the record. i checked to see if the allowedit, and others were set correctly and they are, i also checked to see if the fields we locked and they are not. all of the fields appear ok, combos show available data, etc etc. but they cannot make any changes. if i pull this up in admin mode i see on the bottom of the screen that the recordset is not updateable. what needs to be done to make this work. nothing has changed in this DB for months and this used to function ok, now nothing works?? any and all help will be appreciated. thanks