Update the row source of a combo box in a subform

If you have a subform with a combo box, and you want to change the row source of that combo box in VBA code, use the following:

Dim strSQL2 As String

strSQL2 = "SELECT tblCustomers.CustomerNumber, tblCustomers.CustomerName FROM tblCustomers " & _

" WHERE tblCustomers.CorpAcctNum = '" & Me.cbCorpAcctNum & "' ORDER BY tblCustomers.CustomerNumber; "

Me!frmInputPriceChangeForACustomer_Detail!CustomerNumber.RowSource = strSQL2