Filtering Form

depro

Hi Guys,

I have form wich contain Table Box and at the top I put some fields for filtering that Table Box.

Form has property:
SourceTable: Table1
SourceTableView: WHERE(Field1=CONST(No))


Every filter field contain Variable with accurate data type.

I`ve put code in OnValidate Trigeer in filtering field:

IF PrFilter <> '' THEN
  SETRANGE("No. Pr", PrFilter)
ELSE
  SETRANGE("No. Pr");

What i got in NAV:
When I try to use my filter it`s work only when filter value is in recordset in TableBox.
When I put other value in filter field in TableBox always left one record with incorrect data.

Any idea where is my mistake?


regards,
Depro

ufuk

Add Currform.update(false) on OnAfterGetCurrRecord trigger.

depro

Hi Ufuk,

When I put your code in OnAfterGetCurrentRecord trigger i get error message while opening form:

"There is insuffivient memory (stack) to execute this function.

This can be due to the way that recursive function calls ora used in the program. Contact your system manager if you need assistance"

ufuk

sorry you have to put it OnAfterValidate trigger of your filter field.