View Single Post
Old June 23rd, 2004, 08:04 PM
tlwaltz tlwaltz is offline
Authorized User
Join Date: Jun 2004
Location: Cumberland, MD, USA.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts

Sue, there is no doubt in my mind that you are exactly right.

The statement on page 59 "The third subform needed for frmCustomers is based on tblShippingAddresses." clearly implies that the form is bound. Therefore since Figure 2.20 displays "ShipAddress" in a textbox, that textbox is bound to a field named ShipAddress from tblShippingAddresses.

However, ShipAddress is NOT listed as a field in tblShippingAddresses in Figure 1.19. But ShipAddress is listed as a field in Relationships windows shown in Figure 2.1. And as you correctly pointed out. "In Toy Workshop (Forms Start).mdb the field ShipAddress does not exist as a field in tblShippingAddresses (and in fsubShippingAddress). In Toy Workshop (Forms Finish).mdb the field ShipAddress does exist as a field in tblShippingAddresses (and in fsubShippingAddress)."

So, tblShippingAddresses must have been changed (by adding the field ShipAddress), but that change was not mentioned in the text of the book.

Terry Waltz