Switching from Datasheet to Form View

[tedekgb]

Hi guys

this site rocks

Is there a way to make a command button that can switch a subform's view from datasheet to form view, and vice versa?

Thanks

 

[Autoeng]

You can simply right click on a continous form to switch to datasheet but you can't go back without restarting the form. I'm sure someone can come up with a solution for you as you said "this site rocks". Maybe form repaint.

Autoeng

 

[Tim K.]

Try this out.

Private Sub cmdChangeView_Click()
Me.YourSubformControlName.SetFocus
DoCmd.RunCommand acCmdSubformDatasheet
End Sub

 

[tedekgb]

winner

that's it.

thanks tim