Hi, I'm trying to open a Form and then in this form start a new record with 1 button.

Thanks for replying n greetz,
blaatje

How are you wanting to open the form? Right when you start Access, or fromanother form?

Mike
EchoVue.com

from another form

greetz,
blaatje

Alright these are the steps - you may have some of them done already...

1 - You need a table to link the new form to.
2 - Create the new form
3 - Add a button to the new form, and use the wizard to have it create a new record.
4 - On the main form that calls this form, drop a button, and use the wizard to have it open the new form.

Let me know is you want clarification on any part of that.

Mike

Mike
EchoVue.com

Private Sub Knop11_Click()
On Error GoTo Err_Events_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "EVENTS"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Events_Click:
    Exit Sub

Err_Events_Click:
    MsgBox Err.Description
    Resume Exit_Events_Click

this is the coding part of going to a form with a button,
what we want now is that that same button also opens a new record in that form (in this cause the form is called 'Events')

greetz,
blaatje

Nice & easy! Just add to the end of the OpenForm...

DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd



Mike
EchoVue.com