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.
But I do still want everything to be recorded in the back-end Table. I want to have all of the relevant working information recorded in one place.
You put [Event Procedure] in the combo box's AfterUpdate event property.
The line of code goes in the combo box's AfterUpdate event procedure in the form's module.
There are a gazillion normalization articles out on the web and the wikipedia one is a decent place to start. I kind of like an ad hoc explanation I heard many years ago: When you change any data value, you should only have to modify one field in one record in one table! Clearly putting your PN in two tables is a violation. On the other hand, and this is not carte blanc to ignore the rules, there are rare occasions when practical issues such as performance when it is necessary to break the rules.
I'm not putting the same data in two tables. I have one table that has a record of the programs, with their respective P/Ns next to them. Then, I have another Table with each produced unit, with their corresponding customer/program and P/Ns. I know that the Customer/program and P/Ns are recorded in two places, and I could use a query to match it all up, but that's not what I'm asked for. Unless there's a way to make that still go to a Table, but as I'm understanding, that's not how it really works.
also, using the AfterUpdate procedure,
Option Compare Database
Private Sub Combo69_AfterUpdate()
Me.[Part Number] = Me.Combo69.Column(1)
Me.[____ P/N] = Me.[Combo69].Column(2)
End Sub
doesn't seem to do anything for what I want to accomplish, if anything at all
![](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(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
I'm not putting the same data in two tables. I have one table that has a record of the programs, with their respective P/Ns next to them. Then, I have another Table with each produced unit, with their corresponding customer/program and P/Ns. I know that the Customer/program and P/Ns are recorded in two places, and I could use a query to match it all up, but that's not what I'm asked for.
Marshall said it previously, but I'll reiterate. USERS DO NOT DICTATE TABLE DESIGN! If a user is asking you for a table, then you ask them what is it they want to see. And you give them what they want to see. Users DO NOT get to see or interface directly with tables. They interface through forms, reports and queries.
Right, but it does still make logical sense to record all three values, as they have been known (infrequently) to change over time.