a simple problem i think, but i have no clue

[Traden]

Hi out there,

i have a simple question. Is it possible to open a form in default with the settings for a new record? I want the from when it pops up to open empty, and after entering the first record, you should be able to browse throug the records.
I am not familiar with codeing, tried to copy the code of "add new record" somewhere, but it didn`t work..

any one kay help pls?

 

[casey]

I don't know if this helps, but in the OnOpen Event for your form put the following code....

DoCmd.GoToRecord , , acNew

Then in the form's AfterUpdate Event put the following...

DoCmd.GoToRecord , , acFirst

HTH

 

[KevinM]

From a previous form on the OnClick even of button put....

DoCmd.OpenForm "FormName", , , , acFormAdd

And in the AfterInsert Event of this form put....

Me.DataEntry = False

 

[hi there]

a simple way to do this is create a NewRecord command button using the command button wizard. go to the forms properties (double click on the upper left hand corner box of the form) and select the On Open event. Find the code fo the NewRecord command button and copy this code (Ctrl+C) and paste it into the On Open event associated with the form.

good luck.

 

[Traden]

thanks a lot, it worked!!

cheers Traden