Continious form - hide the new row - add new row with button?

[behedwin]

Hey

I have a continuous form.
I want to add one button in the form header that say, "create new record".

Is this possible?

I only want to see the data that is already in the table that is connected to the form.
I do not want to see an empty row of data where i could enter data if i wanted to add a new record.
But if i press the button create new record, then i want to see the fields so the user can enter a new record.

How am i doing this?


I have tried this:

DoCmd.GoToRecord , , acNewRec

This works in a way but only if i set the option allowadditions to true.
But if i do that i always have an empty row of my fields at the end of the continious form.
So can i hide that row somehow?

 

[behedwin]

Hah
i think i solved it.

I have this code in a button in my form header of my continuous form.

Private Sub Command77_Click()

Me.AllowAdditions = True
DoCmd.GoToRecord , , acNewRec


End Sub

Then on each textbox/control in my continuous form i have set this code to every "on change" event.

Private Sub Text65_Change()
Me.AllowAdditions = False
End Sub

So when i press the button, allowaddition is set to true. Focus is moved to the field of typing in the new data.
As soon as the user types something, the change event is triggerd and sets allow additions to false and hides the new record row.