DoCmd.OpenForm in add mode (A2000)

Topic

New Reply

Unsure of syntax in the DoCmd to open the form in data entry mode. Can you assist?

Dim strFormName As String
Dim frm As Form

strFormName = “frmEnterCSZ”

DoCmd.OpenForm strFormName
Set frm = Forms(strFormName)

E

Reply | Quote

Replies

Use this:

DoCmd.OpenForm strFormName, , , , acFormAdd

or

DoCmd.OpenForm FormName:=strFormName, DataMode:=acFormAdd

The first uses arguments by position, the second by name, but they do exactly the same.

Reply | Quote

Thanks. I was doing this:

DoCmd.OpenForm (strFormName, , , , acFormAdd)

Reply | Quote

DoCmd.OpenForm is not a function, but a procedure, so you shouldn’t use brackets, unless you use Call:

Call DoCmd.OpenForm(strFormName, , , , acFormAdd)

Reply | Quote

DoCmd.OpenForm is not a function, but a procedure, so you shouldn’t use brackets, unless you use Call:

Call DoCmd.OpenForm(strFormName, , , , acFormAdd)

Reply | Quote

Thanks. I was doing this:

DoCmd.OpenForm (strFormName, , , , acFormAdd)

Reply | Quote

Use this:

DoCmd.OpenForm strFormName, , , , acFormAdd

or

DoCmd.OpenForm FormName:=strFormName, DataMode:=acFormAdd

The first uses arguments by position, the second by name, but they do exactly the same.

Reply | Quote