Table lookup doesn't work on form

wilk_u · 2012-01-13

Hi,
i'm working with form 55 purch. order subform it displays some global variable in line, on control displaying this value there was some code in onLookup trigger, then i moved variable through adding it to purchase line table, commented lines in onlookup trigger added exactly the same lines in lookup on field in table. When running table, lookup works, but on form 55 lookup doesnt work, there is just an arrow of lookup, but no action running.. Any clues?
Greetings

Vjeko · 2012-01-13

If you have anything in OnLookup trigger, even comments - the trigger is considered defined, and it takes precedence over table trigger. Delete the commented code, also delete any local variables in the trigger (because as soon as you define a local variable, the trigger is also considered defined), and it will work.

vijay_g · 2012-01-13

Don't comment on control box delete all lines from onlookup trigger of form.

wilk_u · 2012-01-13

Had no idea about that.

Thank You.

lvanvugt · 2012-01-13

Read more about htis here :OnLookup & OnValidate #1

Table lookup doesn't work on form

Comments

Categories