By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,654 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Auto-populate drop-downs

P: 39
Hereís the deal. I'm more of a general Microsoft Admin, so I'm new to Access. My boss wants some type of PO request and tracking system setup, so I read a book on Access since it seems to be the ideal solution. The book gave a great overview, but Itís pretty plain Iím missing out on a lot of stuff.

What Iím stuck on is this. I have a table of inventory items that includes item model, manufacturer, and price. In another table, (form eventually) I just want to be able to select the item model number from a drop-down and have the corresponding price and manufacturer drop-downs populate automatically.

What I tried is using a drop-down lookup that references all three columns for 'model' 'make' and price.' Even though it shows all three, it only input the one value into the table, though.

Any ideas? Is this that hard?

Feb 16 '07 #1
Share this Question
Share on Google+
6 Replies

Expert Mod 10K+
P: 12,342
You have to set up a drop down lookup for each field.
Feb 16 '07 #2

P: 39
I think you're misunderstanding.

There are three columns, price, model, and manufacturer. There's a lookup for each one.

Is there a way to make the manufacturer and price lookups auto-populate when the corresponding model number lookup is selected?

All these lookups are pulling from a seperate table where each model number has a corresponding manufacturer and price.
Feb 16 '07 #3

Expert Mod 10K+
P: 12,342
You can from code in a form. I don't think you can from a table however.
Feb 17 '07 #4

P: 39
Can you give an example of the code?

I know the basics of changing the code in VB
Feb 17 '07 #5

Expert Mod 10K+
P: 12,342
Let's say in the form you have ComboboxA and ComboboxB. A change in selection from ComboboxA will change what's in ComboboxB.

So, in the after update event of ComboboxA you may have something along the following:
Expand|Select|Wrap|Line Numbers
  1. Private Sub ComboboxA_AfterUpdate()
  2. Me.ComboboxB.RowSource = "Select [Field Name] From TableName Where [Criteria Field] = '" & Me.ComboboxA.Value & "'"
  3. End Sub
Feb 17 '07 #6

Expert Mod 15k+
P: 31,308
Does this Tutorial help with your requirement (Example Filtering on a Form.)?
Feb 18 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.