In addition to Sergy's advice - when I use grids, I use an empty DBF structure as the recordsource. When I need to change it, I ZAP the current one, and append a new cursor (or use a reiterative APPEND BLANK) to populate with the new data.
>Greetings all
>
>I am having a problem with event code disappearing or not firing in a grid column. The code in the right click event in thisform.grdItem.column2.text1 does not fire after the grid has been repainted and the event is called upon again before the form is closed. It works fine until the sql cursor re-populates the grid and the grid is refreshed. I issue a DO
in the right click event. I included a wait window before the comand; that also does not fire. I put the same code in all columns, none of them fire. I repeated the above with double click event with the same results. I can't tell if the code is being purged or what because it just does nothning when I right click.
>
>Feeling helpless in Bath
>
>thanks Vince
Imagination is more important than knowledge