View Single Post
  #2 (permalink)  
Old August 25th, 2006, 12:27 PM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Are you sure you don't want a report for this? A subform connotes data enrtry. If you want to display a certain period of time, you would do that in a report.

In any event, base the subform on a query, and put the following criteria in the period field:

BETWEEN [Forms]![frmYourMainFormName].[FromPeriod] AND [Forms]![frmYourMainFormName].[ToPeriod]

When the subform opens, it should contain only those values in the period.

Be sure to set the Parent Child link on the subform to the Account No.

Did that work?


mmcdonal
Reply With Quote