I have a form with a whole lot of text and combo fields. Once the user completes all fields they press a button and that information is used to add a record to a table.

I also have a DataList box on the same form which is linked to that table using ADO DataEnvironment, Connection, and a command cmdTable. This box displays all records in the table (only 1 field for each).

This ADO connection supplies the right data to the list box when the form is opened but I want to update this to show new records as they are added.

I've tried a few things...

'rscmdTextFile is the resulting recordset from the ADO
'... command cmdTable.
DataEnvironment1.rscmdTextFile.Update
DataList1.Refresh

Any help would be appreciated

Cheers Jonny