Filters in one form affecting another...

[Dominaz]

Hello,


I have 2 tables with this info:

Table 1
Student Grade Address
I´ve more than 50 records in this one

Table 2

Student Interview Topics
I have only 4 or 5 records, but with time I will have more (Once I speak with them..)

I´ve also have 2 forms.

The point is I want to make a form where it shows me the results of the "Interview" of the students which have a grade below 2.5 .

How can I do this???
I think i should use a query, but I don´t kno how...

Thanks¡¡

[June7]

You can apply a filter to the form's recordset. Here is one method http://www.datapigtechnologies.com/f...tomfilter.html