Northwind DB: voodoo in Orders form?

[Guest]

Hi,

In the Northwind sample database there's a form named Orders. If you select
an option in the 'Bill to' dropdown, the text boxes directly underneath
change their values. I've looked everywhere and I can't work out how this
happens! There's no binding anywhere, that I can see, between the CustomerID
dropdown and the five fields below it.

I can easily see how the 'Ship to' fields are populated - the values are
simply copied across from the 'Bill to' fields, via the AfterUpdate method of
the CustomerID list - but I have less than no idea how those 'Bill to' fields
are populated.

Any enlightenment would be gratefully accepted!

 

[Sandra Daigle]

No voodoo - just using a little feature that's been in Access for a long
time. The RecordSource query for the form is an AutoLookup query. If you
look at the controls in question you will see that they are bound to fields
in the query. The AutoLookup query is simply a multiple-table query that
automatically fill in certain field values for a new record. Do a search in
help for AutoLookup to find out the specifics.

 

[Guest]

Ah, I'll check that out - thanks very much for your help!