Launching a form in datasheet mode

[stp]

Launching a form in datasheet mode [RESOLVED]

I have a form designed in DS mode. If I open it directly (double click on it on the Panel), it works fine

When opening it programmatically (from a button in another form) it shows just ONE record, in spite of having room enough for several records.

May I get some help to check what am I doing wrong?

thanks

 

[bonekrusher]

Try this

 Dim stDocName As String
    Dim stLinkCriteria As String
    stDocName = "NameOfForm"
    DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria

If thats not what you mean, change the properties of the form from Single to Continuous Forms under the Default properties.

 

[stp]

thanks, I opened the form without the parameter acFormDS, and despite it was declared Datasheet, it was actually shown in Datasheet mode, but only with one record... curious!

It works now.