Filling Fields Automatically

[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?

 

[Ken Snell]

Check out the DLookup function in Help and use it as the control source for
the textbox:

Example:

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