Is there a way to click a button and it opens a query in Datasheet view?
Is there a way to click a button and it opens a query in Datasheet view?
I would never let a user into a query, but how about:
DoCmd.OpenQuery
with the appropriate arguments.
what do you mean with the appropriate arguments?
Look in VBA help for the arguments available for OpenQuery, and use the ones appropriate to your needs.
my code looks like this:
Private Sub Command7_Click()
DoCmd.OpenQuery
End Sub
I keep getting an error saying Compile Error: Argument not optional?
Did you look in Help at the arguments?
Yes, I found what I was looking for...thank you
No problem.