Field Cannot be updated message.

Gregc

Board Regular
Joined
Apr 24, 2002
Messages
75
I have a form with a subform that is basically an invoice for this question. The form and subform both are based on queries. Whenever I enter data on a new line in the subform I get the message "Field cannot be updated.". It doesn't matter which of the four fields you are entering data in on the new line, but it has to be the first character in the new line. But after you hit ok the information goes in the field and all is well. I can't figure out what is causing it to do that.

Any ideas?

Thanks,
Greg
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Figured it out

I had a calculated field based on a calculation in the form query, it didn't like that. So I put the calculation in the control source box of the text box. Problem solved.

Greg
 
Upvote 0

Forum statistics

Threads
1,221,645
Messages
6,161,044
Members
451,682
Latest member
ogoreo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top