Filtering records in MSHFlexGrid on a Form

Hi,
I am trying to sychronise two forms Form1 and Form2 to display filtered data in form2.
I have populated both forms with recordsets(rsEmployee,Orders)respectively. These recordsets are bound programatically to MSHFlexGrids.


How would I filter the "Orders" recordset bound to MSflexGrid using the "filter property" when I change the records in the "Employees" forms.
Note I am using the "EmployeeID" as the link between the two MSFlexgrids bound to the recordsets.
Any help would be much appreciated. Thanks

Albert

You can set by each database recordsource a sql statement

Main database = db1
Second database = db2

example:

' 'database' stands for your table
sql = "select * from database where id="

db2.recordsource = sql & _
' field '0' stands for your table id
db1.recordsource.fields(0).value