pull up data

  • Thread starter Thread starter briank
  • Start date Start date
B

briank

I have a form which I enter the names, addresses, phone
numbers, etc... of vendors and invoice amount. Alot of
the vendors are entered repeatedly while the invoice
amount is different. Is there a way that I can insert a
combo box and upon selecting Vendor A, the other fields
(minus the invoice amount) populate? Also, I want the
flexability to enter new vendors here as well. Is this
possible?
 
Comments in-line.....

briank said:
I have a form which I enter the names, addresses, phone
numbers, etc... of vendors and invoice amount. Alot of
the vendors are entered repeatedly while the invoice
amount is different. Is there a way that I can insert a
combo box and upon selecting Vendor A, the other fields
(minus the invoice amount) populate? Also, I want the
Click to expand...


Check out the "Use the Column Property of a Combo Box" page at

http://mvps.org/access/forms/frm0058.htm

flexability to enter new vendors here as well. Is this
possible?
Click to expand...

See "Add item to combo box using OnNotinList event" at

http://www.mvps.org/access/forms/frm0015.htm

HTH
Steve
 
Back
Top