Making Automatic Updates in a form

[Guest]

I have two questions regarding a form I'm putting together. This is a
shipper form that has the customer address at the top and then a child form
that allows for the listing of multiple items to ship.

First, I want to select the vendor name from a vendor table and then have
the address lines update automatically.

Second, in the child form I would like to enter a part number and then have
the database populate a pull down menu witht he drawing names for that part
number.

Thanks for the help.

 

[Guest]

For the first question, check this link on "Fill Fields automatically on form
based on a control's value"

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

For the second question, check this link on "Searching for a record based on
a text box value in a form"

http://www.databasedev.co.uk/text_search.html

 

[Guest]

You answer to the first question worked perfectly but I might need to further
describe my problem for the second question. The user will enter a part
number into the form and then select the appropriate drawing number from a
pull down menu. The pull down menu is populated by another table that has
information on each part number. There are multiple drawings for each part
necessitating the combo box in the form. I'm assuming this will need to be
based on a query with a where condition but I can't get it to work correctly
because it is a child form.

 

[Guest]

Never mind I figures it out. I didn't realize that when you are dealing with
a control in a subform you have to type [forms]![name of main form]![name of
subform]![field]. Thanks for you help on the first question.