pull up data

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

 

[SteveS]

Comments in-line.....

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

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?

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

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

HTH
Steve