form date filter

[Ali29J]

Hi All

I have a subform based on a query, which i would like to filter from a date picker on the master form, i.e all entries from the date selected onwards.

the subform is based around a query, so i m looking to enter some code in the criteria field which will filter to show all details from the date specified

Can anyone shed some light for me?

Ali

 

[Crowley16]

in your query, you can just reference the date specified on your main form...

--------------------
Procrastinate Now!

 

[Remou]

Hi
Do you mean something like (?):

Me.MySubformControlName.Form.Filter = "MySubformDateField >=#" & Me.MyFormDateField & "#"
Me.MySubformControlName.Form.FilterOn = True

 

[Ali29J]

if i refernce the date only, it will oly show results matching that date, i would like to show everything from that date up until present day

 

[Remou]

How have you set up your query or filter? If you use greater than / equal to (>=) it should show dates from that date on. For example, a query set up as Crowley16 recommends would have something like:

[tt]" ... WHERE MyTableDate [red]>=[/red] # Me.MyFormDate & "#"[/tt]

A filter would look a little like my post above.

 

[Ali29J]

ok thanks for your help, simple used >= forms!form1!DTPicker works a charm

 

[lespaul]

that's what a greater than or equal (>=) to sign means....