updating dbgrid

[xstopx81]

hello, i'm trying to update dbgrid with coding... say if they tried to add a new record, then i get a name and the age with inputbox and then i do it with a code
like

datexample.addnew ...' add and then refresh
datexample.refresh
however, it does not show on the dbgrid. but if i exit the program and start it back, it shows... i know it's kinda confusing but help... i want it to show the newly added record without exiting and restarting the prog

[Hollie]

Try using

datexample.requery

This requeries your recordset and rebuilds it. You may need to refresh your view depending on what type of dbgrid you have.

[xstopx81]

i tried .requery but i get an error saying that member or data member not found

[Hollie]

How do you actually add your information to the recordset?

[xstopx81]

i link textboxes with the datarecordset items and then i do addnew method... the thing is that, dgbrid updates, that is shows the result when i delete a record and the do a data.refresh method

[Hollie]

How do you populate your recordset?

(I had a similar problem last month and using requery solved it for me.)

[xstopx81]

sorry but i don't know what you mean by populating

[Hollie]

how do you put your information into the recordset datexample?

(sorry about the 20 questions)

[Hollie]

Just looking back at your code:

I assumed that datexample is a recordset - is that the case?
What is the name of your dbgrid?

if datexample is a recordset then try refreshing your dbgrid as well
i.e after the record has been added - dbgrid.refresh or call the form refresh procedure

let me know if that works

H.

[xstopx81]

i did that and it still doesnt work... i mean i refreshed the dbgrid as well as the recordset.. and still have the same problems

[Hollie]

hmmmm.....

I'll need to have another think about this one

H.