PDA

View Full Version : Solved: Form in datasheet view



Cass
01-27-2006, 12:11 AM
Hi!
Be i stupid or something but i put the default view datasheet view.
now into switchboard if i open it it is Form view http://vbaexpress.com/forum/images/smilies/doh.gif
switchboard command is "Open Form in Edit Mode"

XLGibbs
01-27-2006, 12:39 PM
So are you having trouble switching the default view ?

What is the code behind the switchboard button if any?

You can edit the properties of the view in Design Mode, next time the form is opened it will open as your choices there dictate..

Cass
01-30-2006, 05:33 AM
So are you having trouble switching the default view ?
You can edit the properties of the view in Design Mode, next time the form is opened it will open as your choices there dictate..

no it must be always open as datasheet view. I change the default view Datasheet and if i open directly, it open as datasheet but if i open into switchboard then formview



What is the code behind the switchboard button if any?

Case conCmdOpenFormAdd DoCmd.OpenForm rs![Argument], , , , acAdd
And now i found the solution

Case conCmdOpenFormAdd
DoCmd.OpenForm rs![Argument], acFormDS, , , acAdd
http://vbaexpress.com/forum/images/smilies/023.gif