Macro to open form in Datasheet view

[grenee]

Good Day All,

I have a form with default open view as Datasheet.

However when this form is opened via a button on another form it opens in form view only.

Can anyone explain how to get it to open in datasheet view in the second case?

 

[RuralGuy]

What code/macro is behind the button?

 

[missinglinq]

Open the Macro is Design View, and with the 'Open Form' command line selected, go to the bottom and in the 'View' option select Datasheet.

Linq ;0)>

 

[grenee]

Thanks All.

I found the problem:

In the Macro in the design view this statement is on the second line : GoToRecord

I deleted if and everything is fine