How to clear the form data in MSAccess?

Question

Hi Good morning to all. I have designed a form using MsAccess in that i was kept one button as New Recordwhenever click on button i want form with new record in that i want to enter some data.but i am getting previous record with data?how to clear that data for new data entry. please help me Thanks inadvance.

srinivas P · Answer

Thanks for your valuable replies and suggesitions.I did my requirement using your repliesthanks for that. One more doubt when i click on new record buttonthen enter the detailsthen save the record.now my requirement is print the current record details as a report(i did report also).how print current Record details. plz help me Thanks inadvance

shaik inthiyaz · Answer

take a button name it as AddNew double clck on button and then write the following code to clear all text boxes example: textbox1.text=; textbox2.text=; textbox3.text=;

Muralidharan Deenathayalan · Answer

Open the database and click the Office Button Click the Access Options button at the bottom of the menu Click Current Database on the left pane Under Application Options click the Display Form drop-down and choose the form you want users to see when they open the database Click OK http://www.techonthenet.com/access/switchboard/startup2007.php

srinivas P · Answer

Thanks for your replyi am using just msaccess database onlyin that i have designed one form for dataentryusing that i have designed one report.now my requirement is whenever click on new record button i want to open a form with new record.and when ever open a msaccess database i want startup page as form(which i was designed).how to write code for startup macro

Suthish Nair · Answer

You need to give more information. What technology using is it a web/windows application etc..

Muralidharan Deenathayalan · Answer

In the new button click event  what are you doing? You have clear all textbox/control values and you no need to move to EOF /BOF. http://msdn.microsoft.com/en-us/library/bb237581(v=office.12).aspx http://msdn.microsoft.com/en-us/library/bb243801(v=office.12).aspx http://www.ehow.com/how_5825494_add-microsoft-office-access-2007.html http://en.allexperts.com/q/Using-MS-Access-1440/Open-form-new-record-1.htm http://www.tutorialized.com/view/tutorial/Insert-a-New-Record-in-Access-2007/40909 Hope this helps you.