So, I realized that I was trying to change the row source from the properties sheet instead of the code -_- Derp on my part.
Also, I think I got it to work Here is da code:
Code:
cboQtyA.RowSource = "SELECT PDatabase.QtyA, " & _
" PDatabase.UnitPriceA " & _
"FROM PDatabase " & _
"WHERE PDatabase.PartNumber = '" & Me.txtComponent & "' " & _
"ORDER BY PDatabase.QtyA " & _
"UNION SELECT PDatabase.QtyB, " & _
" PDatabase.UnitPriceB " & _
"FROM PDatabase " & _
"WHERE PDatabase.PartNumber = '" & Me.txtComponent & "' " & _
"UNION SELECT PDatabase.QtyC, " & _
" PDatabase.UnitPriceC " & _
"FROM PDatabase " & _
"WHERE PDatabase.PartNumber = '" & Me.txtComponent & "' "
I will be expanding on this to include the things mentioned in my original problem. Posted this for anyone else who needs this sort of function.