form view error?

[homeguard]

so i have a form that when i open it up it looks like a datasheet but when i make a button to open it up it looks like a single form. I disabled form view and everything but still get this problem. Anyone had this problem?

 

[Remou]

What is the code behind the button?

 

[homeguard]

Dim stDocName As String
Dim stLinkCriteria As String

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

the stuff the access wizard generated for me.

 

[Remou]

Try:

[tt]DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria[/tt]

 

[homeguard]

aww very good, thank you sir.