open form new record

J

jjeca

Hi

What I want is to ask the user for the name is ok open the continuous form,
position on the new record populating the name field and the field of the
last job they did (incremental number) +1.
So far I have this, and there is a bug when I want to create new record

Private Sub Form_Open(Cancel As Integer)

Dim mdp As Variant
mdp = InputBox("Name?")
If mdp <> "SomeName" Then
MsgBox "Not good"
Cancel = True
Else
DoCmd.GoToRecord , , acNewRec <= it says there is a bug here!?
Me.[job] = Nz(DMax("[job]", "tab_minute", "[name] = 'SomeName'") + 1)
Me.[name] = "SomeName"
End If

End Sub

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top