datsheet view, please help!

[dday01]

I have a a form that has some general agency info on it. I have a button on that form that opens a subform that contains crosstab data based on a query. If I open the subform seperately it opens in datasheet view the way it is supposed to. However when I open the form from the button on the main form it opens in form view (I don't know why this is happening, I have the default view for the subform set to Data sheet). Can any one help me with this? do I need some extra code on the open form event? I'm quite frustrated at this point. Thanks in advance.


Thanks,

DH

 

[TheAceMan1]

How are ya dday01 . . . . .

Add the following line to your button code as the last command:

[blue]DoCmd.RunCommand acCmdDatasheetView[/blue]

See Ya! . . . . . .