Control Cant Be Edited; It's Bound to Expression

davies107

Registered User.
Local time
Today, 13:38
Joined
Oct 2, 2012
Messages
143
Is there a possiblity that a control CAN be edited that is bound to an expression?

All of my Form properties are set to editable, no locks, allow deletion, allow addition, etc.

I just want a text box in a Form to be edited by users if they want to update it but they CAN'T since it is bound to an expression.

Any expert who can help me with this?

Thanks a lot!
 
If it is a calculated in a Query then the information cannot be edited. That is where it stops. If you wish to change the calculation, you have to change the data that resulted in the value.

Example. 5+7 = 12, you cannot change 12 to 10, because that is what you get from 5+7, if you want the value to be 10 you either change 5 to 3 or 7 to 5. Hope that helps.
 
it is not calculated in the Query. its just a text. a text in the Form; not in Table or Query.

like, the issue was Open before then users wants to make it Closed since it was resolved already. They can't change it because the error says it is bound to an expression.
 
Go to the design view, and see what is under the property "Control Source" if it starts with = which means it is calculated in Form level not in Query/Table level. Still same rule applies. Change the Data that it is depending on !
 
Change the Data that it is depending on !
Yep, your users should change the condition(s) that will make it flip from "Closed" to "Open". Your calculation is checking some fields to decide whether it should be "Open" or "Closed".
 
oh i see. i have this on the property sheet of the Form:

=[ListBox].[column(11)]

there is a ListBox that holds all the items, when a user click an item, the information will appear on the textboxes below. challenge for me now is how or what to change with the expression that will change it to Open... im sorry but im no expert in Access.
 
i dont know what expression to create to make it open at the same time the value of the textbox is correct.

i attached my database for further check.

when a user click a Discipline on the top right part (drop down button), items will be shown on the ListBox. once the user pick/click on an item, the information will show below. those information below should be editable for the user to update/edit the item information BUT i dont know what expression or code to place that the information will still be correct once a user pick an item. thats why im here asking for help.
 

Attachments

There are a lot of things not done right in your db but I don't want to going into that. If you need help with organising your tables, designing forms etc, feel free to post a question in the appropriate forum.

Anyway, I've put the controls in a subform control and linked it to your lixtbox using the subform's Link Master/Child Fields and a hidden textbox. You'll notice the only two fields are displaying data when the listbox is clicked, that's because I've not linked them to a Control Source. Easy for you to do.
 

Attachments

There are a lot of things not done right in your db but I don't want to going into that. If you need help with organising your tables, designing forms etc, feel free to post a question in the appropriate forum.

Anyway, I've put the controls in a subform control and linked it to your lixtbox using the subform's Link Master/Child Fields and a hidden textbox. You'll notice the only two fields are displaying data when the listbox is clicked, that's because I've not linked them to a Control Source. Easy for you to do.


wow. thank you so much vbaInet...

yes i know my database is messed up. im not an expert with Access but im learning. can you tell me about whats not right about my database so i can post questions in the forum?

my next challenge now is how to filter the items from the 2 remaining combo boxes.
 
No problem!

Just general help re your tables, normalising it and setting up proper relationships. And afterwards ask about how best to design your form.

That can also go into another thread. But I would advice that you sort out your tables first.
 
No problem!

Just general help re your tables, normalising it and setting up proper relationships. And afterwards ask about how best to design your form.

That can also go into another thread. But I would advice that you sort out your tables first.


i posted already in Tables. and added my next challenge in filtering data from the comboxes
 

Users who are viewing this thread

Back
Top Bottom