473,320 Members | 1,861 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Populating Results in combo or list box from entry on form

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
7 944
PhilOfWalton
1,430 Expert 1GB
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
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
1,430 Expert 1GB
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
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
32,556 Expert Mod 16PB
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
1,430 Expert 1GB
I admire your tact, Neopa, as usual you're spot on.

Phil
May 18 '17 #7
jforbes
1,107 Expert 1GB
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

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

Similar topics

2
by: edworboys | last post by:
I have designed a data entry form with a number of fields and a sub form. The first field (Country) is a combo box and the user selects a country. This, in turn reduces the number of options in the...
1
by: Alex.Wisnoski | last post by:
I have a data entry form with a combo box to look up an entrant's name. If the name is already in the table then it pulls up the record and that part of the form works fine. If the name isn't in...
3
by: Jamie Pittman via AccessMonster.com | last post by:
I am currently using a form to track employee time to customer and warehouse. I want to be able to take information from one record and post this to tne next record(finish time on the first record...
2
by: filbennett | last post by:
Hi Everyone, I'm generally unfamiliar with Access form design, but have programmed Cold Fusion applications for a couple of years. I'd like to build a data entry form in Access that allows the...
4
Rabbit
by: Rabbit | last post by:
Cascading Combo/List Boxes This tutorial is to guide you in the creation of Cascading combo/list boxes. That is when you have multiple combo/list boxes where the selection of an option in one...
7
by: Rotsey | last post by:
Hi, I am loading a tab control on a form. The code loads textboxes and comboboxes and checkboxes, normal data entry form that loads a table row of data. I have a combo on the form above the...
2
by: tolukosi | last post by:
Guys, I am working on my school project using Visual Basic to take Customer Record, Staff Record and To Take Drug Record all in a Drug Store. It will be an inventory software that will take order...
0
pod
by: pod | last post by:
I am new to OOD and n-tier architecture but I want to start the right way. In Visual Studio, I have created a solution with three projects c/w reference to each other i.e. the Business Logic...
2
by: tzoykas | last post by:
Hello all I am trying to create a (simple) database that will hold an inventory of my things, using two tables. One will hold the objects and the other, which object is contained in which. The...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.