Filtering a subform

[flower]

Hi:

I want to filter records based on a date field.
I have 2 tables with a one-to-many relationship. Let's say parent table is table1 and table2 is the child table.
I want to create a form that will display information from both table1 and table2 but it will be filtered based on a field in table2.
I want to display all records where the date field is past today's date or is 10 days from today's date.
I want to display the records in a list.

How can I achieve this?

Thnx
ER

 

[mark curtis]

You can create the form based on a query with the date criteria in the query but if you just wish to view the records then create a report!

 

[flower]

My table2 has fields(child table)

MilestoneDate
Description
Assignee

Table1 has many fields but I just want to display(parent table)
CaptureLead
OpportunityName
OpportunityType

I want that once the Milestonedate criteria matches I want to display this information on a form in a list format. Don't want users to use navigation button.

Can this be done on a form?

Could you please also tell me what criteria should be entered for date field to display records older than today's date or due in 10 days.

Thanx
ER