Auto populate fields in Access FormsLocked
I have searched for answers on previous questions, but not sure I have what I need yet.
Here is my issue…I have a form to enter in PO’s and what I am trying to do is pull in attribute data for a specific item to be displayed so the user does not have to enter the information in again. What I am trying to accomplish is pretty simple, but I cannot get the information to populate my fields. So here is what I have:
sfrmEnterPODetail is where the user enters in information like ItemNumber, QTY, and ReqShipDate. What I want to have happen is for the Desc1, Desc2, UOM, BoardLength and StdCost fields to be populated based on the item entered. My tblItemMaster table has all of these fields. The join is to my tblPODetail table based on ItemNumber. I tried to use a SELECT statement for the Control Source and the Row Source and neither worked. I also tried to create a Query and that is pulling in the attributes for only 1 item, meaning that the first item entered brings in the right attributes, but all other items use those same attributes, which is incorrect.
I hope this is something that someone can help out with rather quickly. Thanks in advance!