Share via

Autopopulate Customer Name based on Customer Code data

Anonymous
2013-07-29T03:06:27+00:00

I am new to Access and I have two tables - one with data tracking changes for specific customers, and one with the customer codes and the customer names on it. I want to be able to input the customer code into the first table and have the company name autopopulate. I'm sure this is something super easy, and I'm overlooking something, but I'm stumped!

Microsoft 365 and Office | Access | For home | Windows

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.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2013-07-29T11:58:23+00:00

    See my blog on Displaying Data from Related tables. It gives several options for this.

    However, do you really need to see the Customer code? The usual way this is done, is by using a combobox that displays the customer name but stores the code.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-07-29T04:56:28+00:00

    Why?  You don't need to store the Customer Name in both tables when you can use a query to show the Cusomter Name any time you want  If you just want to show it in a Field on your Form, you could use...

    =Me.cboYourComboBox.Column(1)

    That is if the Company Name is in column 2 of your Combo Box.

    Was this answer helpful?

    0 comments