Split Form is Read-only - how do I change this?

[JoeyB_99]

I am using Access 2007 and have created a simple query using two linked (Excel spreadsheets) tables.

I have now created a Split Form from it using the wizard(?). That is, I high-lighted the query in the navigation pane and then clicked on the Create Split Form button in the ribbon area. A new split form was automatically created.

The form works well but I want the user to be able to change data, and update the tables behind the query.

Please help. Any input would be graetly appreciated - even a suggestion for an alternative approach.

 

[spikepl]

You can only read data from a linked Excel spreadsheet, update is not possible. You could read the data into a local table from the linked table, modify it and then write it back to a spreadsheet

 

[JoeyB_99]

Thanks spikepl but I have done some modifications and it still tells me that it is noy updateable.

I changed both tables to be imports, and I deleted the calculated field from the query and re-saved it.

Then I deleted the split form and re-created it.

What is wrong? Any ideas/suggestions?