Andrew has attended:
Access Advanced course
Access VBA course
Opening a form in datasheet view
I want to open a form to show a list rather than individual records, via a button. I have set the default view of the form to "Datasheet". If I open the form from the Database window it opens as I want it to, but whenever I open it via the button it opens in Single form mode. Any ideas please?
RE: Opening a form in datasheet view
Hi Andrew,
Behind every button, there is a macro that specifies how the form will display when clicked.
Did you build this macro or did you use the wizard?
If you buld your own macro, use the OpenForm command. One of the properties of this command is the way you want to view the form. Set this property to the one you want, and then allocate the macro to the button.
Let me know if that works..
Regards
Richard