Updating Forms

  • 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?
 
Chris said:
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?
Click to expand...

I'm not clear on what you are trying to do here. The user entering the
amount received implies that the PO already exists (as it should)
That PO will have to be looked up and a combobox would be a good choice.
The original PO should have the ID of the vendor in it and that vendor
information would be displayed by the query the form the is based on.
 
Back
Top