Delete data in textbox Enabled=False

A

an

Hi!

I have a combo with 3 rows.
In Afterupdate I have:

If combo = 3 then
TextboxXPTO.Enabled = False
Else
TextboxXPTO.Enabled = true
End If

Work fine but the last data in this texbox written in previous records are
saved in the table.
How is possible to prevent this, please?
Thanks in advance.
an
 
B

Beetle

If TextboxXPTO is not enabled, then data connot be written to it. If you
have a scenario where you need TextboxXPTO to be enabled, but you want to
prevent data being written or saved to it unless some other conditon is
true/false, then use can use the Before Insert or Before Update events of
TextboxXPTO to trap for this.

HTH
 
A

an

Thanks for your reply.

I need to delete the data in this TexboxXPTO, because there are data in it
of the previous insertion where this TextboxXPTO.Enabled = True.

an
 
B

Beetle

It sounds like you're saying that you need to delete whatever information was
saved in this text box for the previous record, in which case I'm not sure
why you are having difficulty. Move to that record in your form, enable the
textbox and delete the info, or just delete it directly from the table. Or
maybe you're saying that this text box has some default value that is always
there and you want to get rid of that? I'm not sure.
 
A

an

OK, B.

Thanks for your help.
an

Beetle said:
It sounds like you're saying that you need to delete whatever information was
saved in this text box for the previous record, in which case I'm not sure
why you are having difficulty. Move to that record in your form, enable the
textbox and delete the info, or just delete it directly from the table. Or
maybe you're saying that this text box has some default value that is always
there and you want to get rid of that? I'm not sure.
Click to expand...
 
Top