I have an Access form and I would like to have some fields open as blank fields. Currently when the form opens it displays data that was previously entered. I tried using the forms data entry property but that does not work because there are some fields that I do want to open with data. I think I have to set the forms onload property and specify there which fields I want to open as blank. Can soemone tell me how to do that? Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Set form field to blank on open
- Thread starter jjdoro
- Start date
jjdoro,
a form opens with the data that is in the database. If you 'blank' some fields, you are changing the data. If you wish a 'blank field' I suggest that you open an unbound form that is a clone of your bound form. Then you can check the data and add it to your database tables with a SAVE button.
rollie@bwsys.net
a form opens with the data that is in the database. If you 'blank' some fields, you are changing the data. If you wish a 'blank field' I suggest that you open an unbound form that is a clone of your bound form. Then you can check the data and add it to your database tables with a SAVE button.
rollie@bwsys.net
- Status
Similar threads
