 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Update detail record through form
Hello. I'm using Access 2003. My question is how can I update the detail (child) ID field if the user changes the header record through a main form/sub form? ex.: Header ---------- 1 | Joe Smith 2 | Sally Jones 3 | Frank Adams Detail --------- 1 | 1 | Joe Smith detail 2 | 1 | Joe Smith detail 3 | 1 | Joe Smith detail 4 | 2 | Sally Jones detail 5 | 2 | Sally Jones detail 6 | 3 | Frank Adams detail 7 | 3 | Frank Adams detail If the user changes the value in the combo box from Joe Smith to Sally Jones, the detail records need to update to reflect this. How do you do this?? Thanks for the assistance.  SignatureCraig If I understand you correctly, the SubForm (Detail) is kept syncronized by properly completing the SubFormControl's LinkChild/MasterField properties. >Hello. I'm using Access 2003. My question is how can I update the detail >(child) ID field if the user changes the header record through a main [quoted text clipped - 23 lines] > >Thanks for the assistance. SignatureRuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Yes, that's true. However, when the user changes the combobox value, how does the headerID field in the detail table get updated?? As it stands right now, IT DOES NOT. Thanks. SignatureCraig > If I understand you correctly, the SubForm (Detail) is kept syncronized by > properly completing the SubFormControl's LinkChild/MasterField properties. [quoted text clipped - 26 lines] > > > >Thanks for the assistance. How is the value of the ComboBox related to the LinkChild/MasterFields? >Yes, that's true. > [quoted text clipped - 7 lines] >> > >> >Thanks for the assistance. SignatureRuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. |
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
|
©2008 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.