How PRODUCT NAME pops up when we type PRODUCT ID?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)?
 
Use the dlookup("column name","table name","where statement") function in the
afterupdate event for the id field you are entering.
 
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?
 
Back
Top