>Hi,
>
>I've 3 forms, 1 is to show general details, the 2nd will popup to allow user to do a serach and the 3rd will show the search results.
>
>Searching is done using Select SQL statement into a cursor and a grid is used to display result.
>
>My problem is the search result will not be displayed even after i do a refresh on the grid. I've insert a browse command in the 3rd form just to see whats in the cursor, & that the search criteria is correct. Recently I've notice an error occured while running the sql statement - 'alias already in use'. what could it be??
>
>Any help will do.
>
>Thanks
>
>Regards
>Andrew Kong
If SQL is static (not changing on the fly) easiest is to put SQL directly to grid.recordsource and set recordsourcetype = SQL. It seems you set recordsourcetype = alias and the alias is the one you're selecting into. If you still wanna do that way then :
this.recordsource = ""
this.recordsource = SQLalias
Cetin