Command Button Question

[rushhour]

Just a quick question regarding command buttons in forms.

I would like to know if there is a way to open a query from a command button in Access 2007? If so can you please tell me how to do this.

Thanks in advance.

 

[namliam]

well in older versions (2003 and before)

DoCmd.OpenQuery

does that trick for you

 

[rushhour]

well in older versions (2003 and before)

DoCmd.OpenQuery

does that trick for you

Can you explain step by step how to do this please, as I havn't a clue sorry.

 

[namliam]

In the code of your command button (not sure how to do it in 07, but in earlier versions right click your button and click "build event"
Type:
Docmd.Openquery "Your query name here"

That will open the query.. cannot make it easier than that sorry...

 

[RuralGuy]

Have you looked under the Miscellaneous category of the Command Button wizard?

 

[rushhour]

Have you looked under the Miscellaneous category of the Command Button wizard?

Yes I did just before you replied, should have looked closely! It works now thanks. Thanks for your replies but its sorted now. I should have looked closely beforehand.

 

[RuralGuy]

Excellent! Thanks for posting back with your success.