Adding new information via a form

[soorags]

I have created a standard form to add new data to my database but when the form is opened it displays data already stored. I then have to scroll through all of the data shown on the form to the bottom where I can add new data. How can I change this form so that it does not show the rest of the data but lets me just enter and save new data (without having to scroll through the existing data?) I would be grateful for any help. Thank you.

 

[Dimst]

Hellow soorags,

When opening the form in design mode, go to the property and then to the event tab.

At the event On Load the following code can be placed

DoCmd.GoToRecord , , acNewRec

Then the form will give you a blank screen to edit data in it

-Dims

"Wearing sunglasses won't help taking my brightness away"

 

[Remou]

It is also possible to open a form in data entry mode:

[tt]DoCmd.OpenForm "frmX", , , , acFormAdd[/tt]

Or to set the DataEntry property of a form, either manually or through VBA.