Solved Form Issue (1 Viewer)

[jdraw]

?? I have a routine to open a form from code. The form has a default type of Datasheet.
This form has a header with buttons for Close and Refresh.
When execute the code, the form opens as single form?
However, if click the form name in the navigation pane it opens as Datasheet --no header nor buttons.

I'd like it to open as datasheet. I could get rid of the buttons.
I have removed the header and buttons for testing, but it still opens single form???

Looking for a solution/work around/example. (Must be missing the obvious)???

 

[bob fitz]

When execute the code, the form opens as single form?

Can you show us that code?

 

[ebs17]

You mean ...

DoCmd.OpenForm "frmXYZ", acFormDS, ...

 

[Minty]

I think you have to specify acFormDS in the open form method as the default is acNormal .

 

[CJ_London]

you can't show buttons in datasheet view. you would need to use a continuous form

perhaps set the form allow form view property to false as well

 

[Pat Hartman]

If you want buttons, you need to create an unbound main form and place the ds view form as a subform on the unbound main form.

 

[jdraw]

Thanks all. I vaguely recall no buttons on datasheet. Buttons were not necessary.
After a little testing, opening with acFormDS does what I need.
Thanks