Datagrid

[anonymous]

[Originally posted by Nikki]

I would like for the datagrid to display its data the sameway the ms access database table is displayed

In the begining when the tables was first made and then tied into the controls, the datagrid reflected the table identically

now later in the project if I make direct changes to the table in ms access, the datagrid does not reflect the new changes

is there away to make the datagrid reflect the new look of the table in ms access

thanks
Pinkpanther

[anonymous]

[Originally posted by JPicasso]

Grid.refresh?

Check the .Redraw property too

I'm not sure there's a way to just make the data
refresh without knowing that you are supposed to.
that is, if you load a table up, link it to the datgrid,
and then open access and change things,
the datagrid won't be updated unless you .refresh
it.
You should make all changes thru your code and when you do,
call the .refresh method.

[anonymous]

[Originally posted by Leopoldt de Bruin]

I think you need to refresh your recordset. If the database entries are correct , But when you view it in the grid it is still the old data, that is what you must do. If it doesn't work, try even to create a new recorset , reselecting that same string.