Simple Question, Please Help

[AWilderbeast]

Hi Does anybody know how to open a form in add mode through click of a button, i know can be done theough switchboard so it must be able to be done through a button in a form.

Anyone help?

 

[nicola1]

On the properties of your form, set data entry to yes

 

[AWilderbeast]

Thanks alot

 

[dasAccess]

Private Sub cmdHopeThisHelps_Click()
On Error GoTo Err_cmdHopeThisHelps_Click

Dim stDocName As String
Dim stLinkCriteria As String

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

DoCmd.GoToRecord , , acNewRec

Exit_cmdHopeThisHelps_Click:
Exit Sub

Err_cmdHopeThisHelpsd_Click:
MsgBox Err.Description
Resume Exit_cmdHopeThisHelps_Click
End Sub

Is that what you meant, or have I just ruthlessly barked up the wrong tree?