Help me in Access
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)
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.
Last edited by cindyl; January 9th, 2012 at 08:58 AM.