I've created a parameterized view (thanks Barbara!) to grab fields from a number of tables and use the parameter to filter out selected records into my view. (I'm using v3.0)

It works fine the first time. But I can't figure out how to rerun the query to come up with new view results after I've changed the value of my parameter. Requery() was suggested but I'm getting an 'unrecognized command verb' message when I try to do that. After eading about requery(), it looks like it only works with remote SQL views and all of my data is local. Make sense?

If I go into the View Designer and select Run Query after I've changed the value of the parameter, 0 records are selected. It looks like it's using my latest view results to query, not my original tables. Example: first query has the parameter acode=13000 then I need to change the parameter to acode=01010. It's not finding any records so I'm assuming it's not going back to my original tables to find acodes=01010.

Help! I'm sure it's a simple function I need, but I can't find it in my documentation. (btw Barbara, thought I'd give you a little break ;^)...)

Many thanks,

Mandy