addition of new rows in Data grid at run time

[fareeha]

hello,
i am developing an application in vb6.i used data grid in my form to populate it with the records of a table and also to add in more records and update the existing records.using text boxes i add records in it ........but when i add the record.....it is added in the database but it is not appeared in the datagrid at that time .but when i close the form and run it agian then it is listed in the datagrid.
how can i do this that when i add a new record it must be appear at that time in the datagrid.
plz help me
Thanks in advance
fareeha

 

[markharr]

The most likely problem is that the RecordSet has a cursor type of adOpenStatic. You need to change the CursorType to adOpenDynamic.