main logo
Subject: Requery Question
Author: Lynette Tillner
Posted: 2002/04/03 14:45:03
 
View Entire Thread
New Search


OK, my form SHOULD show me all records for a particular filter but they aren't.

When I say:

requery('v_childwparentparam') -- I get the first child record for the filtered set but the navigation buttons are grayed out (and I know there are multiple records to view)

When I say:

thisform.requery()

I get working nav buttons BUT the data is ALL records in the child table (ignores view parameter - does NOT ask for VP -- already knows that because statementon line before is: thisform.mychildbizobj.cparentid = lcparentid)

When I say:

thisform.requery('v_childwparentparam')

I get the following error:

Error #: 1238
Message: No PARAMETER statement is found
Line #: 1
Code: If NOT This.BeforeRequery()
Method: requery
Object: frm_mylookupallchildren


HELP!!! I'm really frustrated here. How should my requery look and get all children for a particular parent in a form set to navigate one record at a time through the children records with the navbuttons on the form?

Thanks,
Lynette
ltillner AT yahoo .DOT com

 
©2002 Lynette Tillner
<-- Prior Message New Search Next Message -->