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
