Error in Northwinds Tutorial?

[DD999]

I was trying to use the Northwinds example to model the tables for a database I need, but the Northwinds database seems to suffer from the same problem I'm having.

In the Order form for Northwinds, you select a customer from a combo box and it brings up the details in a subform.

If you then select a different customer, it keeps the old details from the last customer selected.

How can you make it show the correct details for the new customer automatically when you change the selection in the combo box?

It seems odd that MS let this tutorial go out working incorrectly.

Thanks

 

[Trendsetter]

I'm assuming that you are referring to the value in the combo not reflecting the changed record.
If this is the case then:
In the Form On_Current event enter:
Me.comboName = Me.CustomerID
This assumes that the Primary key on the form is called CustomerID and that the combo has it's bound column set to the CustomerID and is the first column in the query feeding the combo.


Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk