datasheet mode

[jwf]

I have several forms on a switchboard in Access 2010. I need to force 2 of the forms to only open in datasheet mode. Any advice?

 

[pr2-eugin]

When you say reports do you mean Queries that the Reports are based on?

Or you mean reports? I think a report can have only Print view or Normal report view.. I am not sure on this..

 

[John Big Booty]

I'm not sure that it is possible. Perhaps this thread will help.

 

[jwf]

Sorry, it should have forms not reports.

 

[John Big Booty]

I'm sure the OP originally said Report

Given that it has now been edited to say Form, use;

DoCmd.[URL="http://msdn.microsoft.com/en-us/library/office/ff820845.aspx"]OpenForm[/URL] "MyFormName", [URL="http://msdn.microsoft.com/en-us/library/office/ff836050.aspx"]acFormDS[/URL]