Hi Tracy, A little follow-up on the "internal" workings that you see in play here >>>





All DropDownDataWindows (DDDW) having no rows in the primary buffer are "auto-retrieved" when the "container" DataWindow is retrieved.



Therefore, they usually only retrieve as part of the first retrieve for the container DW.





That auto-retrieve is always similar to calling Retrieve without parameters so you need some way to circumvent this auto-retrieve when a DDDW uses retrieval arguments.

"DDDW with no rows" is the "secret weapon"!



You may design the DataWindow object for the DDDW column with one empty row (use the Data pane in the DataWindow painter)

You may from the Constructor event of the container DW insert a row explicitly into each DDDW object, where you want to disable the automatic retrieval

You may set AutoRetrieve = off for DDDW column

-- OR -- you may perform the DDDW retrieve with arguments prior to the automatic retrievals kicking in

When I learned PowerBuilder, there was no "AutoRetrieve" property so we had to learn to use option 1 or option 2 (somehow insert an empty row)









HTH /Michael

I did set the Auto-Retrieve option off.  The reason I can't put the code into the dw constructor event is because the retrieval arguments are not available until the OPEN event of the window fires and apparently the dw constructor event fires first. 

Perhaps modify the OPEN event to retrieve the DDDW before you retrieve or insertrow to the main datawindow..