Form help

[JennBard1]

I was looking at the Northwind Database sample. I wanted to copy something
they did but i'm not sure how it was done.
The question i had was: when you are in their orders table and you select a
customer there mailing address information automatically comes up with it.
Now i am creating a deliveries database in which i have a projects table. I
want to be able to select the project number and have the shipping address
and contact information come up automatically how do i do this?
I may also need to change a shipping address if something is going to a
different area on that site. is this possible (to have the info to come up
automatically and then be able to change it if i need to) or is it only one
or the other?

 

[PC Datasheet]

You can do both of what you ask. Look at the code in the AfterUpdate event
of the control where you select the project number.

 

[JennBard1]

It just says [Event Procedure] i'm not sure at all what that means.

 

[PC Datasheet]

Click the three dots at the far right of where it says [Event Procedure].

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

It just says [Event Procedure] i'm not sure at all what that means.

You can do both of what you ask. Look at the code in the AfterUpdate
event
of the control where you select the project number.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

 

[Van T. Dinh]

See the following Microsoft Knowledge Base articles:

http://support.microsoft.com/?id=95643

and

http://support.microsoft.com/?id=322901

In the sample database NorthWind, the method in the first article is used to
fill Mailing Address details and the method in the second article is used to
fill the Delivery Address details.

Since you want to be able to change the Shiiping details, you need to use
the method in the second article.