>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.


>
>>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