DoCmd OpenQuery

[James Pye]

Hi,

The problem I have is that I need to open a query in datasheet view but in maximum window.

Currently I am using:

DoCmd.OpenQuery "name of query", acViewNormal, acEdit

This opens, but not in a maximum window. Is there a way to do this in VBA, or anything else in Access 03?

 

[wazz]

DoCmd.OpenQuery "qryYourQuery"
DoCmd.Maximize

 

[James Pye]

That works great, thanks for your help.