Forum Discussion

7 Replies

    • Tony2021's avatar
      Tony2021
      Steel Contributor
      Nov 29, 2021

      arnel_gp 

      Hello Arnel,

       

      thank you for the response.  

      I have tested and I have a follow up if you would be so kind. 

       

      Once I click in the Co Name on the form and then cboCurency to choose the currency it doesnt "stick" when I go to the next record and I think its because of the requery.  Do you see what I mean?  

      • arnel_gp's avatar
        arnel_gp
        Steel Contributor
        Nov 29, 2021

        Tony2021 

         

        here is a hack since your form is Continuous, there is actually 1 currency combobox.

        so changing the rowsource of the combo affects the entire form, making some

        of the "values" of combo disappear.

         

        i change the query qryPmtProposal to add currency from currency table (the new calculated field is CY).

        next i added a textbox (txtCurrencyName, see it in property window) and add CY as it controlsource. in the property i also disallow Tabbing to this control. then i right-click and Position->bring to front. While the currency combo the Position is sent to back. I align both controls correct (reducing the width of the textbox).

        next i  remove the Border of txtCurrencyName and add code on it's GotFocus to move the focus to the combobox.

        next i Overlay (the txtbox on top) the txtCurrencyName to the Currency combobox.

        it is now correctly displaying (hopefully).

Resources