Updating Form Fields

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

Chris

I have a form for receiving material. The user first
enters a Purchase Order Number (PO#). After the PO# is
entered, I would like information about the Vendor to be
displayed on a different field on the same form. Then the
user can enter the amount of material received. How do I
make the vendor information appear automatically?
 
Hi,

If you use a combo box to navigate through the records (using the Combo
box wizard for that, as example) on a form with its record source bound to a
query that JOIN the POs with the Vendors table, that would occur
automatically.


Make a query involving the POs and the Vendors. Join the two tables through
their common field, VendorID (I assume). Save the query. Build a fast form
on it, add a combo box, while the wizard is on, make the combo box to find
the PO record related to the one you would enter in the combo box. That's
all (for the "demo" of an easy way about How-To do it).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top