Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Auto populate fields in Access Forms
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!