Displaying access data in ms flexgrid

[davelee]

i am using ms flexgrid to display some data held in an access database but can only seem to get the whole table to display. all i really need is 2 or 3 of the fields from the table and then the user will be required to enter data in the other columns.

Hope someone can help!

 

[Spellman]

What you can do is use and ADO data bound control and a DataGrid. Then code what fields you want e.g.

Dim adors as recordset

sql = "Select field1, field2 from table where condition"
adors.open sql, connection

set ADODC1.recordset = adors

Hope this helps you somewhat. Mark

The key to immortality is to make a big impression in this life!!