> >I want to design a query but I want to pass parameters to the query to be > used as a filter. > > > >The parameters will be passed from an open form. > > > >How can this be done ? > > > >Anthony Griffith > > Create parameterized local view. to do this in the designer or manually use ?parameter e.g. CREAET SQL VIEW .. AS SELECT * ... WHERE field=?cond when you will use the view you will be prompted for a value to use this in a form set NoDataOnLoad for the view (in the DE) and when you want to populate it give "cond" a value and then requery the view Arnon