Make TextBox Editable.

[billy_pit]

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.

Now 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 try to change it but its uselless.

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

Thanks.

 

[billy_pit]

I got the answer so no reply.