>I have two grids on my form. One of the field is a listbox having a valid event that based on a certain condition need to add a record in the second grid.
>
>In my valid event code, I change to my second grid alias before doing the APPEND BLANK. The problem is that even if I switch alias, because I am in a grid, the alias changes back to the first grid which forces the APPEND BLANK to add in the first grid instead of the 2nd.
>
>Here's a sample of the code in my valid event of the listbox of the first grid.
>
>IF condition...
> SELECT alias of grid 2
> APPEND BLANK
> REPLACE ...
>ENDIF
>
>The SELECT alias of grid 2 works but before the APPEND BLANK can be executed, the alias is switched back to the alias of the first grid.
>
>Is there a workaround for that?
Try:
APPEND BLANK IN tablealias
HTH
Tom