Simple datasheet view not working

[dcol]

Hello



Using Access 2007

I've created a form that I was hoping would provide a simple datasheet
Instead, it's showing one page per record

Basically, I've used form wizard:

Selected the table and fields required
Selected Datasheet as the layout
Selected Access 2007 as the style
Given it a name

I've added this to start page as a button
The button executes an event procedure with this code:

Private Sub btn_ConfigureClaimBdxMapping_Click()
    DoCmd.OpenForm "frm_ConfigureClaimBdxNameMapping", acNormal
End Sub

Looking at the properties, it seems to suggest that the datasheet view will open
Yet, when I click on it, the form view opens (one per page)

Any thoughts as to where I am going wrong here?

Thanks

[June7]

Use acFormDS instead of acNormal.

[dcol]

Perfect, thanks
I've also just come across a method that involves embedding the datasheet form inside another form
Your method is much faster as I'm not after a fancy form here