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

shibilyshibily Member Posts: 89
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

Comments

  • vaprogvaprog Member Posts: 1,139
    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;
    
Sign In or Register to comment.