Changing Current Record in a Form

ib000904

Using form 133 (Posted Sales Invoices) i want to create a button that provides the possibility to look for any given text in the Description-field of the Sales Invoice Lines, and when it finds one, set the related Sales Invoice Header as current in this form 133.

So in short: Open the form, press button, enter searchkey 'L07645',
after which the current record of the form is set to the Posted Sales Invoice that contains the word 'L07645' somewhere in field 'Description' of one of its lines.

How to achieve that?

kapamarou

Try the following:

Declare rec133 variable.

rec133.SETFILTER(Description,'*xxxxxxxx*');
IF rec133.FIND('-') THEN
Rec := rec133;

If it works for you add it as a function on the subform and execute it with the parameter description...

Hope it helps.