Novice
Windows 8 
Access 2010 64bit
Hello,
I would like to open Form B by clicking a button in Form A and I want Form B to come up in datasheet view. I've set the default view to datasheet in Form B's properties and when I open it from the objects list I am presented with datasheet view like I wanted but when I open it using a button in another form it comes up with the form view and I have to switch to datasheet view manually. Is there a property in the button or something that I need to change?
Tom
VIP
Windows 7 64bit Access 2010 32bit
Form view is the default, regardless of the property setting, when opening form independently by code. Specify the datasheet option in the code.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 8 Access 2013
Use a macro on the OnClick property for the button.
Open Form
Specify the form name and then chose Datasheet
VIP
Windows 7 64bit Access 2007
DoCmd.OpenForm "FormName", acFormDS
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Main form Datasheet view subform Datasheet view
Date Calculation When Switch From Form View to Datasheet View; Take Two
Totals showing across bottom of Datasheet view
Posting Permissions
Reply With Quote