Field is based on Expression and can not be Edited

[learnaccess3]

I am using a simple query (i.e.) select query taking soem fields , & binding with the controlsource property of the textbox. But I am unabel to edit the same same .Erroe Message when try to enter in that box "Field is based on Expression and can not be edited" .

After clicking on button I am dispalying teh data on 1 form, but some of teh fields only I need to edit & not all.


Request your help.

[NeoPa]

I know you're working in a foreign language but that is no reason to take so little care over your post. You are asking other volunteers to do you the favour of trying to help you with your problem. Do you not even have the courtesy to check your post before submitting it? Let's not see this again please.

To better understand your problem we'd probably need to see your SQL, but to be honest it seems quite straightforward. You cannot edit a calculated field in a query. If you think about it, it doesn't make a lot of sense to.

[missinglinq]

As NeoPa said, you cannot edit calculated data when the calculation is being done in a query or in the Control Source. To be able to edit it, you have to tie your calculation to some event on your form. Typically this would be done in the AfterUpdate event of a one or more controls that hold the component(s) being used in the calculation. The result is then assigned to the field holding the calculated value, and then can be edited.

If you can give us a more detailed explanation of exactly what you're trying to do, I'm sure someone here will be able to help you.

Welcome to Bytes!

Linq ;0)>

[learnaccess3]

Dear NeoPa,
Sorry for the late reply.
I have notunderstood what I have done wrong. I have asked teh question. Do I hv to post in some other section b4 posting.

Sorry for the inconvenince caused.

While retriving a 5 bfields form a table (Out of which 2 fields are say Name,Address shd be editable, other 3 shd be non-editable.) ..

This is not an expression based query no calculation is involved in any field.

Best Regds

[NeoPa]

@learnaccess3
I'll explain it again for you since you ask.

You are submitting your posts with many simple errors of spelling and typos in them. This is laziness. You are also using text-speak which is not allowed on this site (particularly in the technical section). If you want an example, the very short piece that I have quoted above has four obvious typo errors in it. That is in just three sentences.

Notice I don't criticise the English. Those errors we can live with as many of our members do not speak it natively. Typos are simple laziness though, and that is not something that our experts should be struggling with. That is your responsibility to get right before posting. Try reading it first. Most of the errors are very obvious.