Hello Everyone, please help me on this:

On my Access Form(FRM_FCHD and data source: TBL_FCHD ).In this Form, one part is called Office, and here are the fields: OfficeName(combo box), address(list box), city(list box), state(list box), zip(list box)…..all these info should come from my TBL_Office. On my Form, when I select OfficeName_A, all its related information will be auto pop up in the correct fields, and I did fine in here. Here is my code (example for address):
Private Sub OfficeName_AfterUpdate()
Me.Address.RowSource = "select Address from TBL_Office where officename=" & Chr(34) & Me. OfficeName & Chr(34)
End Sub

My problem is: I want to save all these info into my TBL_FCHD, but only OfficeName is be saved, all its related fields (which were be auto pup up)were not be saved into TBL_FCHD.
Sincerely,
Cindy