>Ok- now I need to perform a slightly different REFRESH()...
>
>How can I (manually, via a command button) refersh the data in a grid?
>ALl of the database opening and querying is performed in the form's LOAD() method. Here's what I have at the moment, in a command button's CLICK() method:
>
> ThisForm.LockScreen = .T.
> ThisForm.Load()
> ThisForm.grdToday.RecordSourceType = 1
> ThisForm.grdToday.RecordSource = "today.dbf"
> ThisForm.Refresh()
> ThisForm.LockScreen = .F.
>
>What happens at this point- when the Refresh buton is clicked- is that the grid goes blank. The other command buttons operate normally - the navigation buttons, an editing button, etc.- but I can't see any data. How can I fix this?
>
>My thanks in advance.
>
>Henry
Henry,
-Move database querying to a custom method.
-Before query/requery :
ThisForm.grdToday.RecordSource = ""
* Query
ThisForm.grdToday.RecordSource = "today.dbf"
Alternatively (and better IMHO) use an SQL rowsourcetype.
Cetin