Table Lookup

hi guys,

Here I have a card form where one of the textbox is referring to another table

where user can select record from another table and store it in this text box.

So what I’m looking now is, while this textbox is referring to another table,

I want the table data is filtered by a field in this card form. I don’t know

where to add coding for this table lookup. Do anyone have any idea. Please Help.


You need to write code on OnLookup Trigger of Textbox.


Do you have any coding or link on how to open reference table by filtering and select a record then store in textbox.

ok, I got to solve my problem. thank you Amol