Hidden form query

[ibbledibble]

I think this is a form query but maybe it should be in the macro section.

I have an query that pulls up all the records using a date criteria of on or before today's date. It works fine.

I wanted to use an autoexec macro to run this query and pull up the appropriate form IF there was data in the query.

I desinged the form and when I run it separately from the macro it displays the data. However, when I try to do it through the Macro it doesn't.

I created a separate form based on the original query and gave it a different name. Then I programmed the Macro as follows

Openform FrmDeadlinedateHIDDEN, Form, , , , Hidden
Openform QryDeadlinedate, Form, , IIf([Forms]![QryDeadlinedate]![IPSOref] Is Null,False,True), , Normal
Close Form, QryDeadlinedate, No

What happens is the form opens but it doesn't display any data, even though the query works when I run it outside the Macro.

Can anyone help?
Thanks

 

[ibbledibble]

Sorry I posted this twice by mistake!