Forms come in 3 "flavours":
Single Form (Displays one record at a time.)
Continuous Forms (Displays as many records as will fit in the current
window, each in its own copy of the form's detail section.)
Datasheet (Displays the form fields arranged in rows and columns like a
spreadsheet)
You need to set the form's Default View, plus you may have to specify the
view when you're using DoCmd.OpenForm