Error when changing record data in subform (1 Viewer)

shafara7

Registered User.
Local time
Today, 14:29
Joined
May 8, 2017
Messages
118
I have a loop subform named sfmLoopMess on a Form named frmMess.
Before this, I can change the data from the subform. After a few additions of combobox and stuff outsiude the subform (that I think unrelated to the subform), I can no longer edit what is inside the subform.

I attached the screenshots for better understanding.

For example, when I tried to change/add the date, nothing happen, but an error sound is heard. But I couldn't see any error message popping up.

Any idea why this happend and how to fix this?
 

Attachments

  • Select date error.jpg
    Select date error.jpg
    59.9 KB · Views: 79
  • Table with date.PNG
    Table with date.PNG
    17 KB · Views: 77

isladogs

MVP / VIP
Local time
Today, 13:29
Joined
Jan 14, 2017
Messages
18,186
It is probably now read only

Open the record source for the subform.
See if you can enter data directly into that
 

shafara7

Registered User.
Local time
Today, 14:29
Joined
May 8, 2017
Messages
118
I don't understand what you mean by "See if you can enter data directly into that"
Where exactly? :confused:
 

shafara7

Registered User.
Local time
Today, 14:29
Joined
May 8, 2017
Messages
118
Wait I have checked under Data -> Allow deletion and addition.
It's already set to yes.
Still couldn't find why the error msg is not showing up , if there is an error.
 

isladogs

MVP / VIP
Local time
Today, 13:29
Joined
Jan 14, 2017
Messages
18,186
Wait I have checked under Data -> Allow deletion and addition.
It's already set to yes.
Still couldn't find why the error msg is not showing up , if there is an error.

No that's not what I mean

Open the subform in design view then go to properties


Click the ellipsis (...) next to record source & it will open in design view as a query.


Change to Datasheet View and see whether you can edit data

My guess is that recent changes have affected the subform record source and you won't be able to alter anything.
If so, modify the record source so it is again editable
 

Attachments

  • FormProperties.PNG
    FormProperties.PNG
    10.9 KB · Views: 460

shafara7

Registered User.
Local time
Today, 14:29
Joined
May 8, 2017
Messages
118
Oh sorry for misunderstanding. I have checked, I could not change the data in the query table too.

I have noticed that ever since I added a combo box on the main form, there are errors on the subform.
I guess there is something that is not right with the addition of the combo box.
Because in order for that combo box to do its filtering job, I added other two tables in the form record source.
I thought I fixed it already, but it created other errors. Sigh...
 

shafara7

Registered User.
Local time
Today, 14:29
Joined
May 8, 2017
Messages
118
Thank you for the link!
I have run through the checklist but still couldn't find the culprit for this error.

Is there any VBA code that can override this?

:(
 

isladogs

MVP / VIP
Local time
Today, 13:29
Joined
Jan 14, 2017
Messages
18,186
No
You need to modify the row source.
Suggest you revert to earlier code which was editable.
Then add extra tables one at a time &check after each change whether its still editable

Each extra table makes it more likely to go wrong
 

shafara7

Registered User.
Local time
Today, 14:29
Joined
May 8, 2017
Messages
118
Okay I tried debugging everything.
Turns out I have to change the Record Set Type from Dynaset to Dynaset (Inconsistent Updates) .
It's working now. Thank you :):):)
 

Users who are viewing this thread

Top Bottom