Refrencing open form from external query

[Mike]

I have three databases a front end app database, a backend tables
database and a reports database. I have sucessfully opened my reports
in the external database, however the report refrences a date range on
an open form within my front end app. When the report is opened in the
reports db it cannot see the open form in the frond end app. I am
stumped as to how I can refrence the front end app database (open
form) once (or from) the call is made to the external database report?
Any help is appreciated.

 

[Guest]

odd setup.
you might try using a remote query for your reports record
source.
http://www.vb123.com/toolshed/02_accvb/remotequeries.htm

 

[Mike]

Thanks, However I have already done that. The remote query works
great but it refrences an open form in the front end DB. Thats where
I'm running into problems.

I basically need the remote query to refrence the open form in the
front end app as well as the linked tables in the front end app....

THanks
Mike