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/