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