Linking a spreadsheet (it is a form question)

[cbearden]

When I create a form, it will not allow me to edit or add or delete. I can only view it. Allow Edits, Additions, Deletions, FIlters are all set to yes. Also Recordset Type is not set to Snapshot. Could someone help with this?

Thanks!

 

[Meltdown]

Is the form based on a query that involves more than 1 table?...if so verify the relationship between the tables in the relationship window. Broken relationships = locked forms.

 

[cbearden]

All I did was link the spreadsheet to the database, then created the form through the Form Wizard. Also tried through design view but the same thing is happening.

I do have relationships with 2 other tables. When I created the relationship (dragging field from one table to the other) it said One to Many, now it says Indeterminate for both relationships.

Also, I can edit and add the other two tables(which were created in access without importing or linking), just not the linked spreadsheet.

Thanks for the help!

 

[godofhell]

If it shows undetermined you have your field properties set incorrectly, for instance you have 1 field set as text with no Indexing and the other set as number with Indexing or the fields are not the same type. Check your tables, my feeling is that when you linked the spreadsheet the fields were not properly set so that your relationships are properly maintained.

 

[Lucas]

Unfortunately, you can't delete records from a linked spreadsheet. Adding shouldn't be a problem though...