To execute a query before a window opens, connect the window's aboutToOpenWidget event to the multi-row query part's executeQuery action. This executes the query and fills in the results just before the window opens.