Results 1 to 2 of 2

Thread: Data Control, Ms Flex Grid and query. NEED HELP!

  1. #1
    Guest

    Exclamation

    Hi there,
    I can't filter data with data control in a MS Flex Grid.
    The filter is choosen by selecting some check boxes, each
    of which represents a possible value in the same field.

    A banal ex.
    NAME THE SIGN OF THE ZODIAC
    ------ pisces
    ------ aquarius
    ------ pisces
    ------ pisces
    ------ aquarius

    (*)pisces (checked)
    ( )taurus (unchecked)
    (*)aquarius (checked)

    THANK YOU and please answer as soon as possible.


  2. #2
    Lively Member
    Join Date
    Aug 2000
    Location
    Holden Beach NC
    Posts
    85
    Why not just use SQL to create your recordset?

    txtSQL="Select TableName.* FROM TableName WHERE TableName.FieldName = Value OR TableName.FieldName = Value2 ORDER BY TableName.SomeField"

    Set rs=db.openrecordset(Sql,dbopendynaset)

    (Assumes DAO, I have not used ADO Yet).

    Hunter

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