Open form to New Record

[ivalum21]

I have some forms that I add Students or Classes into their respective tables. Just to make it more user friendly, how do I set it so when I open the form, everything is blanked out and is ready to enter in a new record? Right now I open the form and it displays the first record, then I have to click the button with the sideways triangle with an * next to it to get to a New Record.

Any help would be greatly appreciated!

- ivalum21

 

[PHV]

Take a look at the 5th argument of the DoCmd.OpenForm method (acFormAdd).
You may also consider the DataEntry property of the Form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya ivalum21 . . . . .

You also set the forms [blue]Data Entry[/blue] property to [purple]Yes[/purple] . . .

See Ya! . . . . . .

 

[ivalum21]

It worked great...I just changed the Data Entry property, thank you very much.