[AccessD] how to change form default view via VBA

Stuart McLachlan stuart at lexacorp.com.pg
Tue Apr 17 17:32:27 CDT 2007


On 17 Apr 2007 at 14:09, Billy Pang wrote:

> Hello:
> 
> Is it possible to change the default view of a form in MS Access using VBA?
> I would like to have the user toggle between the datasheet view and the form
> view using a button

Easy enough to go from Form View to Datasheet view with a button which 
invokes DoCmd.DoMenuItem..... 

Trouble is that the button is not visible in Datasheet view so the user 
can't change back.  

-- 
Stuart





More information about the AccessD mailing list