Button Command

[JayX]

Is there a way to click a button and it opens a query in Datasheet view?

[pbaldy]

I would never let a user into a query, but how about:

DoCmd.OpenQuery

with the appropriate arguments.

[JayX]

what do you mean with the appropriate arguments?

[pbaldy]

Look in VBA help for the arguments available for OpenQuery, and use the ones appropriate to your needs.

[JayX]

my code looks like this:

Private Sub Command7_Click()
DoCmd.OpenQuery
End Sub

I keep getting an error saying Compile Error: Argument not optional?

[pbaldy]

Did you look in Help at the arguments?

[JayX]

Yes, I found what I was looking for...thank you

[pbaldy]

No problem.