>>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
>
>Hi,
> I use requery() to re-execute my local views. maybe the syntax is incorrect. You must issue the command like this :
>
>SELECT myView
>=REQUERY()
>
>Hope this help

Ok, now I'm really confused ;). I took your advice, ran the commands and got a messagebox saying 'View definition has been changed'. When I browse my view I still end up with 0 records in my new view although I know there are records where acode='01300' in my master tables. So close....

Mandy