How can I refresh DataBase without closing Form

[chan]

i am working with VB6. i used ADODC recordset. in my Form there is some text box and command bottom. it is about Student Data for example. it can view and add new record. i want a view after adding new record.so how can i refresh DataBase record from Access with closing a Form.

[Comatose]

Do you have any code written already.... if so post it.

[DavidXu]

Hello!

You can invoke "update" method to refresh database.

eg.
datGrid.Recordset.Edit

'To save the value converted of Barcode Value Column
datGrid.Recordset.Fields(3) = strOutput & "-00-00-09-00-F"

'To refresh database
datGrid.Recordset.Update

Greetings,
David Xu

[Comatose]

I've found that most people have trouble with the update method. usually it seems to require some kind of disconnect and reconnect to the database to show changes, and when it does actually work, it's sporadic, and unpredicatable....