View Single Post
  #1 (permalink)  
Old August 25th, 2006, 08:15 AM
mackoy mackoy is offline
Registered User
 
Join Date: Aug 2006
Location: Riyadh, Riyadh, Saudi Arabia.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to mackoy
Default Filter a subform based on value entered

Hi! Im just new here and can anybody would assist me with my problem regarding filtering subform based on "Between two fields value".

I have a main form consisting of the following fields.

Account No
From Period
To Period

The Subform Consists of the following fields

Account No
Period
Net Amount

My problem is how can i filter the subforms 'Period' field based only on the field value that i entered in the Forms 'From Period' And 'To Period'

Hope anyone would help on this.

Reply With Quote