Make TextBox Editable.

[billa856]

Hi,
My project is in MS Access.
In which I have one Form(DatEntry) which I am using for data entry in table(PRODUCTION).
In this Form I have some Textboxes and Comboboxes.
Date,PalletNo,CustomerCode,ItemNo,PONo,Desc,Carton s,Pcs,PartialCarton,PartialCarton1,PartialCarton2, TotalQuantity,Notes.
All are of type Text.
Now when I enter Cartons and Pcs in the TextBoxes after that Total Quantity will automatically count and value of Textbox(TotalQuantity) set to its value.After that when I enter some quantity in Partial Carton Textbox then again TotalQuantity change.
For this I am Using Code as the control source of TotalQuantity TextBox.

=(([Cartons_Text]*[PcsOrCarton_Text])+[PartialCarton_Text]+[PartialCarton1_Text]+[PartialCarton2_Text])

Now sometimes in rear cases I have to put some words like PPK instead of numbers in PartialCarton,PartialCarton1,PartialCarton2.
So at that time this code isn't working.
So I have to manually enter the Value in TotalQuantity Textbox.

But I change the property of TotalQuantity Textbox and set No to Enabled so no one can change it.
But now I want to change in back to normal but still I can't change the value of TotalQuantity Textbox.

I remove the code from the control source property of TotalQuantity Textbox and already try the code in the AfterUpdate event of PartialCarton but its not working.

Private Sub PartialCarton_Text_AfterUpdate()
TotalQuantity_Text=[Cartons]*[Pcs]
TotalQuantity_Text.Enabled = True
End Sub

Even I try to put new Textbox.But when I run the project I can't change the value of it either.it will automatically set the No to Enabled property of new textbox.

I don't know what is going on?
Somebuddy Plz help me.Otherwise I have to design the whole form again.

Thanks.

[Rabbit]

When you set the control source of a control to an expression, that control is no longer editable.

[billa856]

Thanks for ur reply.
I was making something impossible possible.
But now I got my answer.
Thank You.