 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / July 2007Delete data in textbox Enabled=False
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 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 > Hi! > [quoted text clipped - 12 lines] > Thanks in advance. > 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 > 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 [quoted text clipped - 20 lines] > > Thanks in advance. > > an 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. > Thanks for your reply. > [quoted text clipped - 27 lines] > > > Thanks in advance. > > > an OK, B. Thanks for your help. an > 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 [quoted text clipped - 34 lines] > > > > Thanks in advance. > > > > an |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.