Make a page start on a certain record

poppins

Hi everyone,

Let's say I am in a subform and the cursor is pointing to a certain record.
I am using certain fields of the current record (val 1 & val 2) to filter in RecXXX and run another page based on it.

RecXXX.SETRANGE(field1,val1);
RecXXX..SETRANGE(field2,val2);
PageXXX.SETTABLEVIEW(RecXXX.);
PageXXX.LOOKUPMODE := TRUE;
PageXXX.RUNMODAL;

Now, I need in addition to filter on another value (val3) and make the page start first with the record RecXXX that has val1, val2 and val3.
How can I achieve that?

Thanks in advance

kriki

Before the SETTABLEVIEW, try to set the primary key-fields of the record you want to show.

jreynolds

Use PageXXX.SETRECORD.