>>You can't use variables that are declared as LOCAL in a requery. They either have to PRIVATE or PUBLIC, or be form properties (or properties of some object that's in scope).
>
>Sure you can, Fred
>
>I use local variables all the time.

In a requery? Maybe, but I sure can't. I use a custom method called from Requery to my data access object. ;)


>
>
>>
>>>I've followed through the Help text and the manuals, but can't seem to get a grasp on this. I'll enter parameters, and either get a "parameter is invalid" message or get no results whatsoever. Can you point me in the right direction on making this work with parameters and requerying?
>>>
>>>>>Hi all,
>>>>>
>>>>>I've got a form with a grid that is using a view as it's source. The grid shows (among other things) order_no, line_no, part_no, price. I've also got a textbox on the form to allow the user to enter the order # he wants to view. When I enter the order #, I want the grid to show only the records that apply to that order #. I've got it setting a filter and refreshing teh form after accepting the order # in the textbox, but the grid isn't refreshing. The rest of the form is, but not the grid.
>>>>>
>>>>>Any suggestions are greatly appreciated.
>>>>>
>>>>>Thanks!
>>>>>
>>>>>John
>>>>
>>>>Don't use a filter.
>>>>
>>>>Use a view with a parameter. Set the parameter to the order # and requery the view