 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 20082nd Combo box does not change subform
I have 2 combo boxes on a form with the relevant information being displayed in the subform. The selection in the 1st combo box restricts the value in the 2nd combo box and also restricts the data in the subform. Perfect. My problems arise when I select a value in the 2nd combo box. It does nothing to my subform. It does not restrict the data in the subform, (My subform is based on the same table as my form - if this makes a difference?) Any help is greatly appreciated to get the second combo box to filter properly. Hello "Ryan". > I have 2 combo boxes on a form with the relevant information being > displayed in the subform. The selection in the 1st combo box [quoted text clipped - 6 lines] > makes a difference?) Any help is greatly appreciated to get the > second combo box to filter properly. You did not tell us how the filter is meant to be applied to the subform. Are you using the filter property of the subform in the AfterUpdate event procedure (of combo 1) or the LinkChildFields and LinkMasterFields properties of the subform control?  SignatureRegards, Wolfgang Hi Wolfgang I am using the LinkChildFields and LinkMasterFields properties of the subform control. > Hello "Ryan". > [quoted text clipped - 13 lines] > AfterUpdate event procedure (of combo 1) or the LinkChildFields and > LinkMasterFields properties of the subform control? Hello Ryan. >>> I have 2 combo boxes on a form with the relevant information >>> being displayed in the subform. The selection in the 1st combo [quoted text clipped - 6 lines] >>> this makes a difference?) Any help is greatly appreciated to get >>> the second combo box to filter properly. >> You did not tell us how the filter is meant to be applied to the >> subform. Are you using the filter property of the subform in the >> AfterUpdate event procedure (of combo 1) or the LinkChildFields >> and LinkMasterFields properties of the subform control? > I am using the LinkChildFields and LinkMasterFields properties of > the subform control. First: As I understand it, teh main form schould mot be bound to a table at all. Second: Use both properties of the subform control for both combos: LinkChildFields: FieldRelatedToComboBox1;FieldRelatedToComboBox2 LinkMasterFields: ComboBox1.Value;ComboBox2.Value SignatureRegards, Wolfgang Sorry Ryan. I wrote: LinkMasterFields: ComboBox1.Value;ComboBox2.Value This should be: LinkMasterFields: ComboBox1;ComboBox2 (wipe out .Value) SignatureRegards, Wolfgang |
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.