Results 1 to 2 of 2

Thread: Filtering records in MSHFlexGrid on a Form

  1. #1
    Guest

    Post


    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


  2. #2
    Guest

    Post

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width