How PRODUCT NAME pops up when we type PRODUCT ID?

G

Gita

I want to know how I can design a FORM in which when I type PRODUCT ID for
example from one table the PRODUCT NAME pops up in the same form from either
same table or from another table (It does not make any difference)?
 
T

tynerr

Use the dlookup("column name","table name","where statement") function in the
afterupdate event for the id field you are entering.
 
G

Gita

Sorry I dont know where and how to put this expression.
Please let me know if I should put that in design view of the form and how ?
where should I put that and how?
 
Top