>Terry,
>1) Yes the data has changed
>2) Although you can requery a list box, I do not believe you can requery a grid; only refresh.
>3) the data source is tied to a view.
>Hope this helps
>Jerry
Jerry
I was referring to the REQUERY() function, for "refreshing" views:
REQUERY( ) Function
Retrieves data again for a SQL view.
REQUERY([nWorkArea | cTableAlias])
Parameters
nWorkArea
Specifies the work area in which the SQL view is open.
cTableAlias
Specifies the alias of the SQL view. If you omit nWorkArea and cTableAlias, the data for the SQL view open in the currently selected work area is retrieved.
So you don't requery a grid, rather the view on which the grid's based. You requery the view and then (if necessary)refresh the grid
Hope THIS helps
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.