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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding new information via a form

Status
Not open for further replies.

soorags

MIS
Mar 19, 2007
44
GB
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.
 
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

Code:
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"
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top