Forum home » Delegate support and help forum » Microsoft Access Training and help » access course london - Opening a form in datasheet view
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access course london - Opening a form in datasheet view
Resolved · Low Priority · Version Standard
Reply Mon 23 Jul 2007, 16:13Delegate Andrew said...
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?
For upcoming training course dates see: Pricing & availability
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
Reply Mon 13 Aug 2007, 16:06Delegate Andrew said...
RE: Opening a form in datasheet view
Thank you Richard, I think that's what I needed.
Andrew
|