Access 97 Northwind.mdb

H

Howard

In Northwind, orders, there is a combo box to get customer info then when
selected it fills in the form. I am trying to use the same process but I
can only get the company name. I don't see how northwind fills out the other
fields on the form. I see where it fills in the ship to data but not the
bill to. Can anyone help?

Howard
 
P

PC Datasheet

Look at the code in the combo box's AfterUpdate event. That is where the
assignments are being made. I haven't looked at Northwind but that's
typically where it is done.
 
D

Duane Hookom

Steve is correct. The code is:
Private Sub CustomerID_AfterUpdate()
' Update ShipTo controls based on value selected in CustomerID combo box.
Me!ShipName = Me![CustomerID].Column(1)
Me!ShipAddress = Me!Address
Me!ShipCity = Me!City
Me!ShipRegion = Me!Region
Me!ShipPostalCode = Me!PostalCode
Me!ShipCountry = Me!Country

End Sub
 
L

Larry Daugherty

Here is the event and the code...

Private Sub CustomerID_AfterUpdate()
' Update ShipTo controls based on value selected in CustomerID combo
box.
Me!ShipName = Me![CustomerID].Column(1)
Me!ShipAddress = Me!Address
Me!ShipCity = Me!City
Me!ShipRegion = Me!Region
Me!ShipPostalCode = Me!PostalCode
Me!ShipCountry = Me!Country

End Sub

HTH
 
D

Douglas J Steele

I don't think this was called for, Arno. Even you pointed out that "It is
clear that Steve was NOT advertising/jobhunting in this post".

Yes, Steve often violates the intent of the newsgroups, but there's no need
to tar his every action. Save your vigilance for when he is guilty.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



PC Datasheet said:
Look at the code in the combo box's AfterUpdate event. That is where the
assignments are being made. I haven't looked at Northwind but that's
typically where it is done.

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

Poor Steve, you still don't understand... This is *not* a game...
You can't post just like nothing happened.

To all: Explanation and more on this answer to Steve:
http://home.tiscali.nl/arracom/stopsteve.html
It is clear that Steve was NOT advertising/jobhunting in this post, *but*
....
==> Sadly enough this is the second time a real 'hunt' has started.

Again: The idea to stop Steve is as simple as this:
==> Hunt *every* post of PCD, no matter if he is advertising.
==> UNTIL he stops the advertising/jobhunting.

****************************************************
To Steve, who started his blatant advertising and job-hunting again ...
****************************************************
-- You abuse this group and others for job-hunting and advertising over and
over again
-- You are insulting lots of people here when they ask you to stop this
-- You hide your identity while asking questions
-- You try to sell a CD ($125,--) with FREE code you gathered from these
groups here
-- You posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ???
(the latest 'star's': 'Access Resource' and Tom [email protected])
-- There even has been a 'Scam-alert' about you which has been explained
recently in the thread 'To all':
http://groups.google.com/group/comp.databases.ms-access/msg/46038ba2954261f9?hl=en

-- Recently it became clear that you have been spamming innocent people
asking questions:
http://groups.google.com/group/comp.databases.ms-access/msg/4f76d0ed3e5f58ad?hl=en

So why would ANYBODY ever trust a person like you and hire you?
********************************************************

Arno R
 
Top