Filling multiple fields

I am creating a form that by entering a company name from a drop down list it
will then fill in the balance of the address like city, state and others
automatically. Can someone help with this?

Thanks in advance.
Stephen

Look at the northwind database that ships with Access. It does exactly what
you ask on the invoice form.

--
Rick B



"Stephen" wrote in message
...
I am creating a form that by entering a company name from a drop down list
it
will then fill in the balance of the address like city, state and others
automatically. Can someone help with this?

Thanks in advance.
Stephen

"Stephen" ha scritto nel messaggio
...
I am creating a form that by entering a company name from a drop down list
it
will then fill in the balance of the address like city, state and others
automatically. Can someone help with this?

Thanks in advance.
Stephen

Hi Stephen

In NothWind database look at subForm in the orders form.
Try to fill a new procuct and see what happens : is an example that can help
you.

You can also use the property column, see the help for this is clear for me.

ciao, Sandro