N Nuria Vélez Nov 10, 2005 #1 Hi, I need to change the view of a form which is already opened and I don´t want do it with the toolbar. Thanks in advanced
Hi, I need to change the view of a form which is already opened and I don´t want do it with the toolbar. Thanks in advanced
D DavidG Nov 10, 2005 #2 Hi, I need to change the view of a form which is already opened and I don´t want do it with the toolbar. Thanks in advanced Click to expand... Check out "AllowDatasheetView" Property in VB help. Command button for Datasheet view... Forms(0).AllowFormView = True DoCmd.OpenForm FormName:=Forms(0).Name, View:=acFormDS For Form View Forms(0).AllowFormView = True DoCmd.OpenForm FormName:=Forms(0).Name, View:=acNormal HTH
Hi, I need to change the view of a form which is already opened and I don´t want do it with the toolbar. Thanks in advanced Click to expand... Check out "AllowDatasheetView" Property in VB help. Command button for Datasheet view... Forms(0).AllowFormView = True DoCmd.OpenForm FormName:=Forms(0).Name, View:=acFormDS For Form View Forms(0).AllowFormView = True DoCmd.OpenForm FormName:=Forms(0).Name, View:=acNormal HTH
D DavidG Nov 10, 2005 #3 OOPS Datasheet view should have been Forms(0).AllowDatasheetView = True DoCmd.OpenForm FormName:=Forms(0).Name, View:=acFormDS
OOPS Datasheet view should have been Forms(0).AllowDatasheetView = True DoCmd.OpenForm FormName:=Forms(0).Name, View:=acFormDS
