Filling Fields Automatically

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a form that I am using for receiving in Purchase
Orders. When the user types in the PO# I would like the
Vendor Name to be pulled from a different table and appear
on a field in my form. How can I do this?
 
Check out the DLookup function in Help and use it as the control source for
the textbox:

Example:

= DLookup("FieldName", "TableName", "[PrimaryKey] = " &
[NameOfControlOnForm])
 
Back
Top