Access 97 Northwind.mdb

[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

 

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

 

[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

 

[StopThisAdvertising]

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
(e-mail address removed)
www.pcdatasheet.com

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 (e-mail address removed))
-- 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

 

[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

 

[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!)

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
(e-mail address removed)
www.pcdatasheet.com

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 (e-mail address removed))
-- 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

 

[StopThisAdvertising]

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.

Hi Doug,
What you say here sounds very reasonable, but Steve is just *very* immune for reason.

So you think he is not guilty?
Check out the following recent threads here (all from last week):
-- Computer Inventory question
-- Still need to track attendance of bus riders
-- Before i throw myself into Access, a small question....
-- Building a database
-- Phone support
-- Help, no table

Has he learned from previous threads? Apparently not much ...
He is playing games with us and the spirit of the groups.
Playing the nicest of all guys in cdma while advertising as hell again here.

IMO if there will be *ever* a chance to *really* stop him it is this way.
But other idea's are very welcome.

Arno R