Switch Form Views

[gsfmike]

I want to switch a form view from Form to DataSheet with a command button. I figured it was as simple as changing the default view to datasheet (Me.defaultview = datasheet) but error 2136 occurs. Can anyone help with this?

Thanks

 

[WildHare]

I don't believe you can actually "switch" from Form to Datasheet while the form is open, BUT, what's to stop you from putting a SUBFORM control there in DATASHEET mode, and simply making it visible and bringing it to the front when you want "datasheet" mode?

Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[cmcg22]

I know its an old thread but what the hell.

In a macro simply use the sendkeys function and put in %vs as the keystrokes i.e. alt-v,s to change views via the menu. Assuming you've got normal menu on the form, but you can always define your own menu including the function.

While I'm here thanks to everyone, don't know what I'd do without you guys.

Carl