Sub Form Datasheet Delete issue

chrisjames25

Registered User.
Local time
Today, 19:24
Joined
Dec 1, 2014
Messages
404
Hi

I have a main input form which i enter all my production batches on. Within the form i have a subform that shows each entry as i input them.

ONce i have inputted the weeks entries i double check eac hdata entry and then when im happy i click upload data. (see image).

Only at this point is the data added to my proper database.

This worked fine up until yesterday. If i had found an error in any of my data inputs i would simply right click the line of data that was wrong and choose to delete record. I added one column to the subform yesterday and somehow i have lost the ability to delete records now. I didnt play with any properties so no clue what i have done. Any ideas?
 

Attachments

  • Error33333.jpg
    Error33333.jpg
    94.9 KB · Views: 60
It would appear that the added field has made your query/record source read only. Check whether you can edit records.
 
Further update. I have found the cause of the problem. Just not the why it is causing the problem.

I have a qry that forms the datasheet. This qry uses multiple tables. Yesterday i added an additional table so i could add genus to the datasheet. As soon as i do this delte is no longer an option for me. Any idea why this is occurring?
 
Hi. See image of the qry design. The table that makes it read only is Tbl_Genus. BOttom left corner.
 

Attachments

  • Query111111.JPG
    Query111111.JPG
    80.6 KB · Views: 66
Hi RIdders. THink i have sorted it by deleting the joins between cateroy table and genus table and genus table and variety table.

What i am not sure of is why i had to do that?
 
Further update. I have found the cause of the problem. Just not the why it is causing the problem.

I have a qry that forms the datasheet. This qry uses multiple tables. Yesterday i added an additional table so i could add genus to the datasheet. As soon as i do this delte is no longer an option for me. Any idea why this is occurring?

As I said, your query is now read only. See this link for reasons http://allenbrowne.com/ser-61.html

EDIT posts crossed
Looking at your screenshot, the golden rule is to only have one path joining tables.
You had created a loop
Also probably an issue with the multitude of one to many joins in the various links
You were right to remove the extra link.
TBH with this many tables, it's hardly surprising if the query is read only
Read the article by Allen Browne for more info
 
Last edited:

Users who are viewing this thread

Back
Top Bottom