Changing view of subform

[Domac]

Hi,

How to switch form Datasheet view to Form view using code???


Thanks in advance!


Domagoj

 

[Domac]

Sorry , i mean Subform !

How to switch Subform from Datasheet view to Form view?


Thanks!
Domagoj

 

[Pieter Wijnen]

Don't think you can after it's loaded, you have to set it's default open
mode in design view

Pieter

 

[Domac]

Thanks, Pieter!

I will find alternative solution.



"Pieter Wijnen"

 

[Brendan Reynolds]

You can switch a subform between datasheet and form view ...

Private Sub Command1_Click()

Me.NameOfSubformControl.SetFocus

'1 = form view, 2 = datasheet view ...
If Me.NameOfSubformControl.Form.CurrentView = 1 Then
DoCmd.RunCommand acCmdSubformDatasheetView
Else
DoCmd.RunCommand acCmdSubformFormView
End If

End Sub

 

[Pieter Wijnen]

Thx, good thing I hedged my bets <g>

--
Pieter Wijnen

My feeble Access pages (good links though)
http://www.thuleeng.com/access
When all else fail try:
http://www.mvps.org/access
http://www.granite.ab.ca/
http://allenbrowne.com/
http://www.lebans.com/