Menu
Unbound combo box used to filter data on subform. No matter what you do with the combo box, if it's not bound to a field of the parent form's RecordSource,.
I am trying to get (2) pages of the tab control to filter subforms based on a combo box entry. I can't get the Filter property to work or an embedded macro run a query. I had received some advice as follows: 'From your mainform, you can set a Filter on a Subform like this: Me.NameOfYourSubformCONTROL.Form.Filter = ' dwfTitleNo=1' Me.NameOfYourSubformCONTROL.Form.FilterOn = True Note the NameOfYourSubformCONTROL; this may or may not be the same as the form you're using as a SourceObject, so be careful with that. This would be done in the AfterUpdate event of your combo.' However, when I used this code with my 'NameOfYourSubformCONTROL' = cboSig and cboEvals for each corresponding subform, it did not recognize the code after Me.cboSig. Then I put in the name of the form: frmMasterTabForm just in case they meant.Form to be the Form Name, but no dice. RE: Filter continuous subform from combo box selection MS Access 2007 (Programmer) 10 May 10 01:20.
Duane, I looked into your suggestion, however the main form is already sorting the subform for docID (tblDocInfo PK relationship one to many with tblDocWorkFlow dwfDocID fk). I am posting the tblDocumentInfo below. In addition to filtering for docID on the main form, I need to filter (2) subforms on the tab control for dwfTitleNo from the tblDocWorkFlow depending on which subform they are entering data into. I do not think what you are asking makes any sense, or how the subforms are set up makes any sense. I would think everything on the draft eval subform should represent a draft evaluation.
![Access 2007 Filter Subform Using Combo Box In Access Access 2007 Filter Subform Using Combo Box In Access](/uploads/1/2/5/6/125645298/789714483.png)
Everything on the signature tab should represent signature. If it was me I just get rid of the combo. Or can you explain what it is supposed to do? (I do not think an eval changes into a signature, Instead a new record is created for the signature.) Instead I would have a hidden textbox with the default value set to 1 and bound to the dwfTitleNo. Then the rowsource query of the draft eval subform should include include a criteria: WHERE (tblDocWorkFlow.dwfTitleNo)=1) Now this form only shows dwfTitleNo's = 1 and enters only 1 for new records. Same idea for signatures.
See if this makes sense. Duane, The OP did incorporate some normalization in the tblDocWorkFlow. They never fully got it. That is actually why there is a 1 for draft and a 2 for signature, kind of using your suggestions. RE: Filter continuous subform from combo box selection MS Access 2007 (TechnicalUser). I just went over the previous thread. The work flows look like a great idea.
![Access 2007 filter subform using combo box in access account Access 2007 filter subform using combo box in access account](https://bytes.com/attachments/attachment/3750d1281535911/02.jpg)
I went ahead and changed the work flow table to incorporate the dates and employee info. From what I understood, I modified the Work Flow Titles table to handle each step: manager signature, QAQC signature, SOP Lead Signature, etc. I am going to revise the forms to reflect it. Thank you for connecting me to the original post.
I attached the updated tables for the database just in case you were curious, looks like you put a lot of time into this project. Thanks, Mike.