Have a datasheet subform with two combo boxes. CBOcontractorid is just a drop down and pick the contractor. CBOPayrate is using a query to go back cbocontractorid on subform to get payrate for that contractor.
I have also put a afterupdate requery macro on cbopayrate
So record 1 of the subform I choose Susan as a contractor and then in the combo box of cbopayrate the rate of 25 comes in. Perfect. Except, it makes me choose from the drop down to get the (Only) payrate value versus me it just filling in the value.
The real problem is when I go to the second record of the subform. Choose my contractor it will bring up the rate from the first record not the rate related to this contractor. It does not requery to give new correct rate.
I have tried many things and I know it is simple but help