 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2007Clear a form on entry
How does one clear all of the fields when entering a form? I have two forms (one query and one data entry) and the user does not want to see the previous results. I attempted to use the forms on open and on load events to set the field to null (field.value = NULL) but it did not like that. Is there anything else I can do? Thanks for all of your help! For the form in question simply set the 'Data Entry' property to Yes. This way when your user opens the form it will be on a new blank record. You can also blank each control by code such as Me.ControlName="" Daniel P > How does one clear all of the fields when entering a form? I have two forms > (one query and one data entry) and the user does not want to see the previous [quoted text clipped - 5 lines] > > Thanks for all of your help! Thank you Daniel, it worked perfectly. > For the form in question simply set the 'Data Entry' property to Yes. This > way when your user opens the form it will be on a new blank record. [quoted text clipped - 13 lines] > > > > Thanks for all of your help! Three ways to open the form for data entry, empty form 1. Set the form DataEntry Property to Yes ==================================== 2. On the On open form command line, specify that it for data entry docmd.OpenForm "FormName",,,,acFormAdd ==================================== 3. On the OnLoad event of the form, insert the code to move to a new record DoCmd.GoToRecord , , acNewRec  SignatureGood Luck BS"D > How does one clear all of the fields when entering a form? I have two forms > (one query and one data entry) and the user does not want to see the previous [quoted text clipped - 5 lines] > > Thanks for all of your help! Thank you Ofer, that worked perfect. > Three ways to open the form for data entry, empty form > [quoted text clipped - 15 lines] > > > > Thanks for all of your help! |
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
|
©2008 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.