>This might sound a bit stupid to u but could you please tell me how parameterized views will solve this problem and why do we use them? I have never used them before and will appreciate your time and response.
>Thanks.
The idea of p-view is that it retrieves limited number of records (usually all childs pertained to particular parent), i.e. SQL-string looks like: SELECT ... From ChildTable Where Childtable.Parentid=?nParentid. So, when record pointer moves within parent record, it's enough to reset the parameter: nParentid=Parenttable.Id and issue =Requery("MyPview") to get new set of records. It's pretty common way and used widely (IMHO, it's unnecessary to use for read-only recordsets like list or combo rowsource).
Edward Pikman
Independent Consultant