 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / July 2007sync'd combo boxes on subform
Ok, let me see if I can describe this well enough to be understood. I have a form which holds customer main information, then I have a subform which has tab controls. I have combo boxes and text boxes that are enabled or disabled depending on what the user chooses. The problem is that what is enabled or not needs to stay within the individual record of the subform. However, what is happening is that if a user chooses one thing on the first record and then moves to a new record (on the subform) and chooses something different it enables fields that shouldn't be enabled on the first record. Is there anyway to prevent this from happening? >I have a form which holds customer main information, then I have a subform >which has tab controls. I have combo boxes and text boxes that are enabled [quoted text clipped - 3 lines] >record and then moves to a new record (on the subform) and chooses something >different it enables fields that shouldn't be enabled on the first record. You need to use the enable/disable code for all the options in the subform(?) Current event in addition to each individual control's AfterUpdate event.  SignatureMarsh MVP [MS Access] That is exactly what I have. The problem comes in when moving through the records on the subform; the next record will change the first records txt boxes, etc. that are enabled or disabled. Is there a way to prevent that? > >I have a form which holds customer main information, then I have a subform > >which has tab controls. I have combo boxes and text boxes that are enabled [quoted text clipped - 7 lines] > in the subform(?) Current event in addition to each > individual control's AfterUpdate event. Are you saying the subform is in continuous view? If that's the case, then you can not use a VBA procedure to enable/disable controls without getting the visual effect you are trying to avoid. Instead, you need to use Conditional Formatting (Format menu) on each of the controls that you want to enable/disable. SignatureMarsh MVP [MS Access] >That is exactly what I have. The problem comes in when moving through the >records on the subform; the next record will change the first records txt [quoted text clipped - 11 lines] >> in the subform(?) Current event in addition to each >> individual control's AfterUpdate event. No it is not a continous form. The view is "form" view", each tab is a different section pertaining to the case associated with the member info on the main form. A member can have mulitple cases that is why the subform (tab's) has multiple records associated with it. However the view is not datasheet or a continues form. > Are you saying the subform is in continuous view? > [quoted text clipped - 20 lines] > >> in the subform(?) Current event in addition to each > >> individual control's AfterUpdate event. I'm confuse! If the subform's records aren't being shown datasheet or continuous how do you know what record B is doing to the controls on record A? >No it is not a continous form. The view is "form" view", each tab is a >different section pertaining to the case associated with the member info on [quoted text clipped - 7 lines] >> >> in the subform(?) Current event in addition to each >> >> individual control's AfterUpdate event. SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Then it sounds like you might have a problem coordinating the multiple subforms. You might(?) be able to overcome at least part of this problem if you don't enable/disable all the subforms from the main form and use each subform's Current event instead ( and possibly the tab control's Change event. SignatureMarsh MVP [MS Access] >No it is not a continous form. The view is "form" view", each tab is a >different section pertaining to the case associated with the member info on [quoted text clipped - 11 lines] >> menu) on each of the controls that you want to >> enable/disable. |
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.