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

Populating Results in combo or list box from entry on form

P: 7
Is there a way to use a form in Access where you enter in information in one box and it will populate options in another box? Example: I have a table that has numbers and descriptions in it - the numbers are tied to the descriptions, but there can be multiple descriptions for one number. I would like to be able to put the number in one box and then choose from the list of descriptions that only go with that number from another box. I am wondering if this is even possible. Thank you for your help.
May 18 '17 #1
Share this Question
Share on Google+
7 Replies


PhilOfWalton
Expert 100+
P: 1,430
Probably, but we will need a bit more information.

Can you post in design view the relevant part of the table, and the corresponding data.

Also, having selected a description, what do you want to do with it?

Phil
May 18 '17 #2

P: 7
This is the only information that is in the table (other than the auto ID field that is created by Access). One field is the number and the other field is the description. I have an entry form that I am using a combo box to pull up the information in now. The information that I select from that combo box (along with other information that is entered on the form) is then put into another table that I pull the search query from. I am trying to see if there is an easier way for me to pull up the descriptions instead of scrolling through them. Hoping that I can enter the number in one "field" on the form and that in the other box (either combo or list) it will populate only the descriptions that go with that number. Then this information that is selected will be saved in the other table (as it is now). Hope that helps to clear it up. Thanks
May 18 '17 #3

PhilOfWalton
Expert 100+
P: 1,430
Sorry, I can not help further.

I asked for specific information, and although you have partially answered what it is used for, the first two questions remain unanswered.

Phil
May 18 '17 #4

P: 7
Well thank you for your time, but I cannot provide the information that you are specifically asking for. I provided the information that I was able to.
May 18 '17 #5

NeoPa
Expert Mod 15k+
P: 31,494
Hi Denielle.

I can understand there being issues posting data in public. That's a common problem. Are you sure posting a table design is unacceptable though? That would be very unusual. In fact, if that's the case then I'm not sure why you'd post such a request for help. Without even the table design it would be difficult even to understand the problem properly. Short of a perfectly-expressed question, and like most this is certainly that (Perfectly-expressed questions being extremely rare.), how could anyone be expected to help?

If you find that posting the design is acceptable after all then the data shouldn't be a problem. It may take some time and trouble to prepare some data that is not real but behaves in the way described, but that shouldn't be enough of a problem if you're asking someone to spend their time to help you. Surely?
May 18 '17 #6

PhilOfWalton
Expert 100+
P: 1,430
I admire your tact, Neopa, as usual you're spot on.

Phil
May 18 '17 #7

jforbes
Expert 100+
P: 1,107
From the way you describe you tables, I think you might benefit by researching and understanding Database Normalization and Table Structures Without this understanding, what you are running into becomes pretty common.

It's also one of the reasons asked for the information that he asked for.
May 19 '17 #8

Post your reply

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