lookupTextbox

mohasin

Hi,
I want to add textbox which provide LOV/drill down/dropdown of values,values that are comming from column of paticular table from databse .

please reply me ,its urgent

udayrmer

surely you can do it

write below code on Onlookup, OnDrilldown of the textbox,

Rec.SETRANGE(x,1)
Rec.SETRANGE(y,2)//apply appropriate filters you need

IF FORM.RUNMODAL(0,Rec) = ACTION::LookupOK THEN
Var := Rec.z

x,y,z are some field of that record.

set properties of the textbox, Lookup = yes, drilldown = yes

mohasin

udayrmer wrote:

surely you can do it

write below code on Onlookup, OnDrilldown of the textbox,

Rec.SETRANGE(x,1)
Rec.SETRANGE(y,2)//apply appropriate filters you need

IF FORM.RUNMODAL(0,Rec) = ACTION::LookupOK THEN
Var := Rec.z

x,y,z are some field of that record.

set properties of the textbox, Lookup = yes, drilldown = yes

where i will get Onlookup, OnDrilldown
what the var here
please give me clean example with complete explanation
i am unable to understand above example

udayrmer

On textbox, Press F9 you will get OnLookup, OnDrilldown,

Var is source expression of that textbox