Access DB - Make me look like a fool!

[Dymetrie]

AAAARGH!

Slightly stuck with an Access DB, on something that I know how to do and have done before but now can't figure out...

Does anyone know how I make a form open with a new record rather than at 'record 1'?

It's really getting on my nerves now

Thanks in advance to whomever it is that makes me look like a fool

Dym

[Feek]

My DBA said "Open it as an insert rather than a query"

Then he said "Tell him GIYF, that's a stupid question"

[Dymetrie]

It's not opening as a query, the command link merely opens the form...

The other DB I have opens as a new record, but despite trying to figure out what's different between the two I'm stumped :/

I am also stumped by that acronym

[Burble]

Originally Posted by Dymetrie

I am also stumped by that acronym

GIYF = Google Is Your Friend.

I'm very very rusty with Access but am sure I've done this before. Lemme see if I still have copies of the old stuff.

[Dymetrie]

If it's any help, this is the VB code...

Private Sub Visit_Logging_Click()
On Error GoTo Err_Visit_Logging_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

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

Exit_Visit_Logging_Click:
    Exit Sub

Err_Visit_Logging_Click:
    MsgBox Err.Description
    Resume Exit_Visit_Logging_Click

[Dymetrie]

Ok, so the DB which does work has a macro to create a new record, I just can't figure out where it kicks in...

This is most perturbing now

[Dymetrie]

AHA!

Finally found something which actually works

Have changed the code to:

Private Sub Visit_Logging_Click()
On Error GoTo Err_Visit_Logging_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "Visits"
    DoCmd.OpenForm "Visits", , , , acFormAdd

Exit_Visit_Logging_Click:
    Exit Sub

Err_Visit_Logging_Click:
    MsgBox Err.Description
    Resume Exit_Visit_Logging_Click

Will find out if that borks everything when I need to use the DB tomorrow morning