 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007Updating main form from subform
Sorry I previously posted this in the wrong topic Wont't do it again. I have a tabbed form which works fine other than the fact that when I change tab, the record field [ComplaintNumber] located on the subform of main form does not update on the other tabs, meaning on the main form, as these if I get it right are just extensions of the main form. The [ComplaintNumber] is defined on a subform placed on main form. On the main form when I choose a customer ID, the complaintNumber is created by an expression on the sql statement followed by an auto number. It looks like this: Customer ID number: PEC-12 ComplaintNumber: PEC-12-112 I need to see this number updated on the other tabs, which are also based on the main form and other tables, so that I can add corresponding data for this particular record. I have the OnChange and OnClick events from the Tab form properties, byt to avail. Many Thanks, Chris1 How many tables do you have and what are the relationships. I suspect you are making this more difficult than required. > Sorry I previously posted this in the wrong topic Wont't do it again. > [quoted text clipped - 18 lines] > Many Thanks, > Chris1 I have TblCustomer and TblComplaintPhase1: The main form (tab form) is based on a query using both tables. The other two tables are: TblFullResponsePhase2, and TblFullInvestigation3 relationships: 1 to many between TblCustomers and TblComplaintPhase1 1 to many between TblComplaintPhase1 and TblFullResponsePhase2 1 to many between TblComplaintPhase1 and TblFullInvestigation3 1 to many between TblFullResponsePhase2 and TblFullInvestigation3 Possible scenarios are: Phase 1 + Phase 2 + Phase3 Phase1 + Phase3 Many thanks, Chris. > How many tables do you have and what are the relationships. I suspect you > are making this more difficult than required. [quoted text clipped - 21 lines] > > Many Thanks, > > Chris1 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.