[AccessD] Use global variable in a query? <SOLVED>

Sad Der accessd666 at yahoo.com
Mon Oct 27 07:33:23 CST 2003


Sometimes Access amazes me....
docmd.openform <formname>,,,<WHERE CONDITION!!>

I created a form with a table as a recordsource.
lalalala and added the where clause to the openform
method! 

Workes like a charm.

SD
--- Sad Der <accessd666 at yahoo.com> wrote:
> Hi group,
> 
> I need to build a lot of detail forms. Their nothing
> more then a select * from table. Off course with the
> exception of 2 where statements.
> 
> The query needs 2 parameters I use throughout the
> program.
> 
> Question: Is it possible to use a global variable in
> query? I do NOT mean an sql-statement but a query
> created and saved in the database itself (HTMS)
> 
> If not...any ideas? I mean I need to build a LOT of
> detail forms!
> 
> Regards,
> 
> Sander
> 
> __________________________________
> Do you Yahoo!?
> Exclusive Video Premiere - Britney Spears
> http://launch.yahoo.com/promos/britneyspears/
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/


More information about the AccessD mailing list