Solved Form not opening as expected (1 Viewer)

[mib1019]

I've got a weird thing happening; hopefully can get some advice here.

I am working on a new form. Designed it as continuous form, which I will later develop with some filters, buttons. For now the datasheet serves the purpose.

I have set these properties of the form:

Default View: Datasheet​

Allow Form View: No​

Allow Datasheet: Yes​

Allow Layout View: No​

When I open the form from the navigation pane, it opens correctly.

I put a button on my 'Dashboard' to open it. It reads like this:

Private Sub cmdJournalArchive_Click()
On Error GoTo cmdJournalArchive_Click_Err

    DoCmd.OpenForm "Journal Archive"
    
cmdJournalArchive_Click_Exit:
    Exit Sub

cmdJournalArchive_Click_Err:
    MsgBox Error$
    Resume cmdJournalArchive_Click_Exit

End Sub

​

From the Dashboard, the form opens as a Single Form.

What's going on? Have I completely lost my mind?

Thanks in advance for the help!
MIB

 

[theDBguy]

From the Dashboard, the form opens as a Single Form.

I think that's the default behavior, try adding the Data Entry Mode argument (I think it's acFormDS) to your OpenForm code.

 

[mib1019]

Thank you DBguy. I was just looking again at the arguments and found that. It's the only form I'm opening in acFormDS so I'd forgotten about that argument being necessary.

I've been in lockdown for too long.

 

[theDBguy]

Glad to hear you got it sorted out. Cheers!