Using Access 2003 I have a table called POTable which contains 4 fields. PONOID (primary Key and AutoNumber), PONO (text), VENDOR (text), GENDESCRIP (text). I have another table called MRRTable. This table contains several fields with one of them being PONOID (number). What I want to do is the following: I want to create a new record in my MRRTable each time a shipment arrives (MRR = Material Receipt Record). I need create a user friendly form to have an admin perform this entry rather than myself or someone going into the back end and simply adding to a table or query. This form I want to create for adding a new MRR to the table must contain the PO number. I don’t want the person to start entering a new record only to find out there is no PO Number for this item and they have to stop in mid stream. So, what I was thinking was to set up a main unbound form which has a combo box listing all the PO numbers/Vendors in the table. The admin would look at the combo box and select the PO number for that specific shipment (If the PO isn’t there, they would select a separate button to add the PO information this adding it to the combo box). After the PO number has been selected from the combo box, I then want them to click the "Add MRR" button and go to the Add MRR input form (thinking this would be a subform already in the main form). When the focus is moved to the Add MRR subform, I want the PO Number (PONOID) to auto populate in the field called PONOID which is a field in the MRR Table. Then they can fill out the rest of the fields per the directions. When complete, they will click “Add Package No” button and it will take them to the additional subform called Add Package No. ready to enter a new record for the package table but bringing down the newly created MRR # and auto populating it into the MRRNOID field in the “add package no” input form. It's a progression. All I need to do is figure out how I can get the value from the original combo box to populate a designated field in my subform called Add MRR which is going to used to create a new record in that MRR Table. Suggestions? Is this a good approach? Any help will be most appreciated. Thanks, George Bullo
Software/Hardware used: MS Access 2003, Windows XP
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!