Set the focus to a specific row in a list form.

shibily

Hi all,

I am working on a list screen where i am populating the week cycles (start date, end date). The week starts from monday and ends on Sunday.
I have a requirement to focus the last week cycle whenever i open the screen.
for example say, i am now in the week cycle 10/10/2011 - 10/162011, i need to get set the focus to the previous
week ie 10/03/11 - 10/09/11 when i open the screen. Start Date and End Date are two different fields.
How it can be achieved?


Thanks in advance

vaprog

There are several options to achieve that.
First, you need to leave all form properties that set table placement at default. Then you can use

// Find the record in MyRec that you want to focus in the form here
FORM.RUN(FORM::MyForm,MyRec);

Or with a form variable:

// Find the record in MyRec that you want to focus in the form here
MyForm.SETRECORD(MyRec);
MyForm.RUN;

Or from within the form:

OnOpenForm=BEGIN
             MyRec.COPY(Rec);
             MyRec.SETRANGE("Start Date",CALCDATE('<-CW-1W>',WORKDATE));
             IF MyRec.FINDFIRST THEN
                Rec := MyRec;
             FIND('=<>');
           END;