Set Textbox value by selecting item from combobox but it must be editable

[billa856]

Hi,

I have one projrct in MS Access.
I have one form in which there is one Combobx(PalletNo_combo) and one Textbox(ShippedQuantity).
Now when I select an item from Combobox then it will automatically set the value of Textbox.
For that I am using code in control source properties of Textbox

=(DLookUp("val([QTYONHAND])","PRODUCTION","PalletNo=[Forms]![ShippingEntry]![PalletNo_Combo]"))

Uptil here its fine.

But after that, in some scenario,I have to change the value of that Textbox.
But when I click on the Textbox and enter something then it will show me this

control can't be edited;it's bound to the expression
(DLookUp("val([QTYONHAND])","PRODUCTION","PalletNo=[Forms]![ShippingEntry]![PalletNo_Combo]"))

So I want to change the value in only some cases,like 1out of 100,if i have to change it then what to do?I want to make that Textbox Editable so i can edit it
How can i do that?

Thanks

[BradHodge]

Hi,

I have one projrct in MS Access.
I have one form in which there is one Combobx(PalletNo_combo) and one Textbox(ShippedQuantity).
Now when I select an item from Combobox then it will automatically set the value of Textbox.
For that I am using code in control source properties of Textbox

Uptil here its fine.

But after that, in some scenario,I have to change the value of that Textbox.
But when I click on the Textbox and enter something then it will show me this



So I want to change the value in only some cases,like 1out of 100,if i have to change it then what to do?I want to make that Textbox Editable so i can edit it
How can i do that?

Thanks

I would think that instead of setting the Control Source of your textbox to the combo box, I would use the AfterUpdate Event of the combo box to plug in it's value to the textbox.

You have likely got the Limit to List property of the combobox set to Yes, and therefore, since the text box is pulling it's info from the combo, it is not editable either.

Brad.

[billa856]

Thanks buddy its working.