I've also tried to point it to PricePerUnit control source. I do see when debugging that the cboRequestedItems does have the correct chose value but the PricePerUnit never populates and comes up with error 2465.
Somewhat closer. Now I get the error 2113: "The value you entered isn't valid for this field"
I still get the correct data when I hover cboRequestedInventory so I went in to the both tables to see that they have the correct data type. RequestedInventory is set as text. PricePerUnit is set to currency. I changed the data type to text just to see if I could get any data to come up on PricePerUnit on the form.
The exact data that is selected in cboRequestedInventory comes up in PricePerUnit...?
Why don't you post back with more details about exactly what you're attempting here, such as;
What table does the combo box get its data from?
What fields are returned by the combo (and in what order)?
Which column in the combo contains the data that you want to store in the PricePerUnit field and what is the data type?
It sounds like the PricePerUnit field is in the record source of a different sub form than the one where the combo box is, but please clarify that as well.
Lastly, why do you want to do this? If the value is already stored in one table (the one the combo box is based on), then is there a reason to store it in another table as well? It may or may not be good practice to be doing this to begin with, depending on the circumstances.