Updating multiple tables in Access 2000

  • Thread starter Thread starter Liz
  • Start date Start date
L

Liz

I'm probably brain dead, but . . .
I have a dept. schedule table that contains scheduling
info that can be moved to our maste scheduling database. I
want to have my staff use a form to edit the dept.
database and have those changes reflected in the master
schedule. I can create the form, but am locked out from
updating even though the data fields are unlocked.

Any suggestions?? Thanks!
 
Can you make the edits if you use the query that feeds the form? If not,
then it sounds as if you don't have an updateable query. Are there any
calculated fields in the query? Access won't try to reverse the calculations
to save data back to the tables.
 
Back
Top