Auto open form given query parameter - Access 2010

[Hotwheels59]

I have a query that returns a true/false result. If the result is true, I would like Access to automaticallly open a form based on an On Open command in another form. Any help is much appreciated.

[June7]

That query is RecordSource of a form?

What do you mean by 'automatically'? Some event must happen. You want to open form A which is bound to the query? You want code in that form Open event to immediately open another form if field of form A is true?

[Hotwheels59]

Thanks for the question... Once form A opens, I would like it to call a query, determine whether the parameter is true, and if so, open form B.

[June7]

If the query is not included in form RecordSource, could do a DLookup on the query. Does the query result in a single record?

Or maybe even a DLookup (or DCount, DSum, etc) on the raw dataset.

[Hotwheels59]

The query indeed results in a single record.

[June7]

Are you familiar with domain aggregate functions? Access Help has guidelines.

[Hotwheels59]

No, I'm not. But I can take a look. Thanks.