>>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
>Mandy,
>
>I'll bet you are using VFP 3.0 right? Well in 3.0 you need to preceed any fuinction call with an = sign to get it to be accepted, so your requery() call needs to be ;
>
> =Requery("Theviewname")

You got it! Thanks! ... so much for the manuals and help files ;)!

Mandy