>> i need to know which is the best choice between Select all my records in the Load event of my form (and wait) or to select a portion of the table
IMO, you should only pull the amount of data needed by the user or the operation. Although users might want to fish through 150K rows, I doubt that it would be useful. Better would be to implement paging and or a search facility that would allow the users to identify the rows that are required.
-Mike