This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am using Microsft Access 2007. I have a form that has a drop-down menu to select a customer from a separate table. I have a text box next to it for the part number, and another text box next to that for the program number. The P/Ns are specific to each customer. So, I would like to make it such that, in this form, when a customer is selected from the menu, the P/Ns automatically generate. How can this be done?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I don't know what to tell you, but I'm putting in that code in the AfterUpdate, changing it for the actual names of the boxes, of course, and it's still not doing *anything* at all.
No, I know. I had the combo box previously, and I had the dimensions set to 1";0";0". I'm going to give it another go, though. Do I need to text boxes to record the P/Ns? Or can I just do it without showing it on the Form?
That's exactly what I have been describing all along. I guess the thing you missed was that combo69 RowSource query needs all three columns.
To copy the two part numbers you will need two lines of code:
Me.FPNtextbox = Me.Combo69.Column(1)
Me.APNtextbox = Me.Combo69.Column(2)
Let me try something else. If I use a combo box drawing from my Customer / Final Part Number / Assembly Part Number database, I can get a drop-down menu with three columns, with all of the relevant data lined up. Is there a way to record all three of these columns? Because as far as I can tell, I can only choose to record one column.
You lost me. You seem to be implying that there is more than one part number text box.
If you use a combo box instead of a text box to display the part number for the selected customer selected in combo69, then you open the door for selecting a part number for a different customer. I think you should forget this thought and concentrate on getting the arrangement to work. The key things to check is everything about the combo box, the control source of the text box and the names of the controls and fields.