Wrox Programmer Forums
|
Forum and Wrox.com Feedback Post your suggestions for improving the Forums or Wrox.com or questions for the staff here. "Where can I find the code for my book?"
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Forum and Wrox.com Feedback section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 11th, 2010, 04:29 PM
Registered User
 
Join Date: Aug 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Filter subform from button on main form

I'm trying to filter my subform based on two txtboxes and a button on the main form.
txtBeginDate and txtEndDate is the criteria I'm trying to filter the subform with but I'm having a hard time. Keep in mind that I'm not a progammer and know very little.

The fppeDate is the date in the subform that I'm trying to filter. Trying to show just the records that occured between those two dates.

Dim FilterString As String
Me.Dirty = False 'This saves any changes to make sure they appear on the QualityReviewDetails form.
FilterString = "fppeDate = Forms!MonthlyOutput!fppeDate >= me.txtBeginDate And Forms!MonthlyOutput!fppeDate <= me.txtEndDate "
Forms![FPPE]![fppeDate] = FilterString
Forms![FPPE]![fppeDate].Requery

Thanks in advance for any help!

Last edited by kawi6rr; August 11th, 2010 at 04:32 PM..





Similar Threads
Thread Thread Starter Forum Replies Last Post
Synchronizing main form w/subform (i.e. backward) paladin Access VBA 7 April 19th, 2007 06:40 AM
Moving total from Subform to Main Form Shepwad Access 1 March 10th, 2006 10:57 AM
updating main form from subform dartcoach Access 6 April 28th, 2005 08:27 AM
how to parse filter from a form to a main form flyfish Access 1 February 1st, 2005 05:36 AM
Filter subform from main form DBoulos Access VBA 2 October 30th, 2003 12:20 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.