PDA

Click to See Complete Forum and Search --> : Data Control, Ms Flex Grid and query. NEED HELP!


Oct 15th, 2000, 02:12 PM
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.

HunterMcCray
Oct 16th, 2000, 11:02 PM
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