More FlexiGrid/Data problems

[briggsy79]

Hello again,
I seem to have spent more time on this website than creating the program lately...
I have a form with a FlexiGrid that after a record has been searched for and edited needs to be refreshed. But when the refresh button is clicked a new column appears named "Expr1000". I would like to delete/hide this column but i dont know how. Also, it then controls the ordering of my records, so they are all out of their original sequence.
The flexiGrids data source is a "Data" called dtaReporterv5 (which is linked to an access database via JET) and i refresh both of them with the click. I think this is where the problem lies as if i stop the dtaReporterv5's refresh (it happens other times in the program) the new column doesn't appear, but i need to refresh it sooner or later (maybe not?).

Thanks for reading any help would be greatly appreciated

 

[SirLee]

I think this is related to your Access query not the MSflexgrid. I would try to hunt the problem down in your database queries and eliminate it there.

 

[Guest_imported]

I agree with Sirlee the problem sound like it is in the database not the program. Expr is like a default name for a column created with no name in access.