|
-
May 9th, 2010, 09:04 PM
#2
Thread Starter
Member
Re: Filter continuous subform from combo box selection MS Access 2007, Office 2007
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.....
any ideas???
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|